Variable LOCAL_POSTGIS_BOOTSTRAP_SQLConst Experimental
LOCAL_POSTGIS_BOOTSTRAP_SQL: "DO $$\nBEGIN\n IF EXISTS (\n SELECT 1\n FROM pg_extension e\n JOIN pg_namespace n ON n.oid = e.extnamespace\n WHERE e.extname = 'postgis' AND n.nspname <> 'public'\n ) THEN\n DROP EXTENSION IF EXISTS pgrouting;\n DROP EXTENSION postgis;\n END IF;\nEND\n$$;\nCREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;\nCREATE EXTENSION IF NOT EXISTS pgrouting WITH SCHEMA public;\nCREATE TABLE IF NOT EXISTS public.zero_to_map_parcels (\n parcel_id integer PRIMARY KEY,\n name text NOT NULL,\n geometry geometry(Polygon, 4326) NOT NULL\n);\nINSERT INTO public.zero_to_map_parcels (parcel_id, name, geometry)\nVALUES (\n 1,\n 'origin',\n ST_SetSRID(ST_GeomFromText('POLYGON((-157.86 21.30, -157.85 21.30, -157.85 21.31, -157.86 21.31, -157.86 21.30))'), 4326)\n)\nON CONFLICT (parcel_id) DO NOTHING;\n" = ...
Extensions must live in public. The server resolves unqualified
geometrythere.