PostgREST schema cache broken: tables/views return PGRST205; RPC functions return PGRST202 #41840
Unanswered
Elstranapps
asked this question in
Questions
Replies: 1 comment 6 replies
-
|
Do you have the API turned off?
|
Beta Was this translation helpful? Give feedback.
6 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment


Uh oh!
There was an error while loading. Please reload this page.
-
Subject: PostgREST schema cache broken: tables/views return PGRST205; RPC functions return PGRST202
Summary:
I'm experiencing an issue where PostgREST is returning PGRST205 ("Could not find table in schema cache") for tables that definitely exist in my public schema. I've tried restarting my project and triggering schema reload via
select pg_notify('pgrst','reload schema'), but neither resolves it. This is breaking both my REST API access and Edge Functions.What I've tried:
to_regclass()returns non-null)publicin dashboardselect pg_notify('pgrst', 'reload schema');has_schema_privilegeandhas_table_privilegereturn trueImpact:
Related issue found in community:
I found this thread where someone had PGRST202 errors with RPC functions. Their solution was:
NOTIFY pgrst, 'reload schema'But my situation differs:
pg_notify('pgrst', 'reload schema')and project restartshas_schema_privilegereturns true)My question:
Has anyone experienced this? Are there other troubleshooting steps I should try before potentially needing to contact support? Could this be related to schema cache corruption?
Beta Was this translation helpful? Give feedback.
All reactions