sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

CREATE FUNCTION relation already exists

Open Git-me-outta-here opened this issue 4 years ago • 0 comments

I am creating two distinct functions but sqlc (both v1.7.0 and v1.8.0) seems to think they are the same function!

CREATE FUNCTION myfunction(text[], text[]) RETURNS real
    LANGUAGE plpgsql
    AS $_$
DECLARE

and

CREATE FUNCTION myfunction(text, text[]) RETURNS real
    LANGUAGE plpgsql
    AS $_$
DECLARE

The error: relation "myfunction" already exists

Playground

https://play.sqlc.dev/p/afc48eca64c2a3d37feae81b57a7ee1a0bb0e6346d02879ac84c383e27b04730

Git-me-outta-here avatar May 06 '21 13:05 Git-me-outta-here