How to do HTTP Request on the mart scheme?
Hi everyone,
I have a table mart.dim_product inside a custom schema mart.
The schema is included in pgrst.schemas (public,mart), and I’ve granted full privileges (USAGE, SELECT, etc.) to postgres, service_role, and authenticated.
However, the Supabase REST API still returns "relation 'public.dim_product' does not exist" — it seems PostgREST doesn’t recognize the table in the mart schema even though the configuration looks correct.
Restarting the project and running NOTIFY pgrst, 'reload schema'; didn’t help.
Any ideas why the REST API can’t access tables outside the public schema?
I have a table mart.dim_product inside a custom schema mart.
The schema is included in pgrst.schemas (public,mart), and I’ve granted full privileges (USAGE, SELECT, etc.) to postgres, service_role, and authenticated.
However, the Supabase REST API still returns "relation 'public.dim_product' does not exist" — it seems PostgREST doesn’t recognize the table in the mart schema even though the configuration looks correct.
Restarting the project and running NOTIFY pgrst, 'reload schema'; didn’t help.
Any ideas why the REST API can’t access tables outside the public schema?
