PostgREST schema cache stuck - existing tables return 404
PostgRESTProject: cyjrsdxpomtiutpkxnck
Issue: PostgREST returns 404 for existing tables (profiles, groups, group_members)
Error: "Could not find the table 'public.group_members' in the schema cache"
- Tables exist in database (verified via SQL)
- Permissions are correct (anon/authenticated roles have access)
- Tried: multiple migrations with NOTIFY, project pause/resume
PostgREST schema cache not refreshing after migrations
- Problem persists for weeks
SQL verification shows tables exist:
SELECT table_name FROM information_schema.tables WHERE table_schema='public';
Returns: profiles, groups, group_members, activities, etc.
But API returns 404:
GET /rest/v1/profiles -> 404
GET /rest/v1/groups -> 404
Request: Manual PostgREST schema cache invalidation
Issue: PostgREST returns 404 for existing tables (profiles, groups, group_members)
Error: "Could not find the table 'public.group_members' in the schema cache"
- Tables exist in database (verified via SQL)
- Permissions are correct (anon/authenticated roles have access)
- Tried: multiple migrations with NOTIFY, project pause/resume
PostgREST schema cache not refreshing after migrations
- Problem persists for weeks
SQL verification shows tables exist:
SELECT table_name FROM information_schema.tables WHERE table_schema='public';
Returns: profiles, groups, group_members, activities, etc.
But API returns 404:
GET /rest/v1/profiles -> 404
GET /rest/v1/groups -> 404
Request: Manual PostgREST schema cache invalidation
