Generating types with postgis extension lead to file with lint errors.

[pcardosolei]

Bug report

Describe the bug

When generating the Database Model via supabase cli if there is an postgis extension activate in its file the functions provided generate errors on the linter.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

• activate postgis extension on supabase.
• run supabase gen types typescript

Expected behavior

functions that are more clear on the types.

Screenshots

System information

• OS: [e.g. macOS, Windows]
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Additional context

Add any other context about the problem here.

[sweatybridge]

Thanks for reporting this issue. May I check if you installed postgis in extensions schema or created its own postgis schema?

[pcardosolei]

@sweatybridge hey.

Just did this code on tableplus directly.

CREATE EXTENSION postgis;

SELECT AddGeometryColumn ('public','advertisements','geom',4326,'POINT',2);

[soedirgo]

Hey there, we just fixed this on our side - can you try regenerating your types?

Also, you might want to create the extension in the extensions schema instead to not pollute the generated types:

create extension postgis schema extensions;

[pcardosolei]

it is fixed with the latest update.

Will take a look at the comment. Thanks!