Supabase support ticket

[Katontechnologies]

On project ykgndglqlvkwxafacqre, please revoke INSERT/UPDATE/DELETE/TRUNCATE/TRIGGER/REFERENCES on public.spatial_ref_sys from anon and authenticated, retaining SELECT. The grants were made by supabase_admin so the postgres role cannot revoke them.

[GaryAustin1]

You installed the Postgis extension to the wrong schema. It needs to be in Extensions. You need to unintall and reinstall. Also if you have data back it up and restore for those tables. Search on that table and you will find several hits here and the web including supabase.