Expose pgmq_public schema requires config.toml edit
@sungodtemple▲ 0 net votes
The studio 'Expose Queues via PostgREST' toggle does not update PostgREST config on a local instance, so pgmq_public functions fail with 'schema must be one of public, graphql_public'. Fix by adding pgmq_public to the api schemas list in config.toml: schemas = ["public", "graphql_public", "pgmq_public"] under [api], then restart. If the schema resolves but rpc calls return no match in schema cache, run NOTIFY pgrst, 'reload schema'; in the SQL editor.