PGRST106 Error when accessing public schema through API

[owengot]

I have also messaged support about this and they are doing their best to help me, but posting here in case someone has an idea.

I am getting the most bizarre error when querying my database via the javascript client:

{
    "code": "PGRST106",
    "details": null,
    "hint": null,
    "message": "The schema must be one of the following: storage"
}

I have tried the following with no success:

• Checked my exposed schemas in the API settings (includes public and storage)
• Tried restarting the server
• Tried creating a new schema with grants to access existing tables and specifying this in the javascript client - same error message
• Checked grants / table privileges for 'anon' through the dashboard SQL editor which confirms anonymous user has access to the "public" schema

SELECT * FROM information_schema.table_privileges WHERE grantee = 'anon'

It seems that the Supabase API specifically restricts access to only the "storage" schema.

One day ago, the storage was upgraded by a member of the team to enable resumable uploads - I can't help but think the two issues are linked since we have had this database running for seven months now without a problem up until now. But I simply cannot see where it is coming from.

[steve-chavez]

"message": "The schema must be one of the following: storage"

That indicates PostgREST is only configured with storage as an exposed schema.

Try doing:

ALTER ROLE authenticator SET pgrst.db_schemas TO 'public, storage, graphql, realtime';
NOTIFY pgrst;