PostgREST Issues
PostgREST returns "relation 'users' does not exist" (42P01) for UPDATE operations even though the table exists in public schema, all permissions are granted (anon/authenticated/service_role), schema USAGE is granted, RLS is enabled with policies, and SELECT operations work fine. I've verified the table exists, confirmed permissions with has_table_privilege(), added .schema('public') to queries, tried NOTIFY pgrst commands (didn't work), and even using secret key still fails. Is this a PostgREST schema cache issue that requires PostgREST to be restarted to refresh the cache? If so, how do I request this? I've created RPC functions as a workaround that work (bypass PostgREST), but I'd like to fix the root cause.
