Issue with enabling extensions that depend on postgis

[samrose]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

it appears that supabase users cannot use postgis_topology and postgis_tiger_geocoder extensions in the same supabase instance, because of conflicts with schemas. I tested and confirmed this on debian packaged 15.1.1.79 and 15.6.1.96-nix-staged same exact behavior in both (staging test).

postgis_topology and postgis_tiger_geocoder will install and work if postgis is installed under the same schema (topology schema for postgis_topology and tiger schema for postgis_tiger_geocoder ).

[wolfuser99]

up