Subject: PostgREST Schema Cache Not Updating After Configuration ChangesBody:
Hello Supabase Team,
My PostgREST schema cache is not updating despite multiple attempts to reload it. This is blocking our production application.
Project ID: dtoyuunlyzszoqkzhxfe
Issue: After adding sdr_data to "Exposed schemas" in API Settings, PostgREST still returns:
PGRST106: The schema must be one of the following: public, graphql_public, users, geographies, common, grouping, entities
Steps Taken:
Added sdr_data to Exposed schemas in Dashboard → Settings → API
Added sdr_data to Extra search path
Ran NOTIFY pgrst, 'reload schema';
Paused and resumed the entire project
Waited 30+ minutes for cache refresh
Verified permissions: GRANT USAGE ON SCHEMA sdr_data TO authenticated;
Verified function exists: public.insert_amicable_settlements_wrapper is executable by authenticated role
Result: PostgREST still cannot see the schema or function. API returns 404/406 errors. Attached is the sql proof also.
My PostgREST schema cache is not updating despite multiple attempts to reload it. This is blocking our production application.
Project ID: dtoyuunlyzszoqkzhxfe
Issue: After adding sdr_data to "Exposed schemas" in API Settings, PostgREST still returns:
PGRST106: The schema must be one of the following: public, graphql_public, users, geographies, common, grouping, entities
Steps Taken:
Added sdr_data to Exposed schemas in Dashboard → Settings → API Added sdr_data to Extra search path Ran NOTIFY pgrst, 'reload schema'; Paused and resumed the entire project Waited 30+ minutes for cache refresh Verified permissions: GRANT USAGE ON SCHEMA sdr_data TO authenticated; Verified function exists: public.insert_amicable_settlements_wrapper is executable by authenticated roleResult: PostgREST still cannot see the schema or function. API returns 404/406 errors. Attached is the sql proof also.
