Enabling exposure of Queues via PostgREST is temporarily disabled

[craft365]

How can I restore(using brew) the functionality of 'Expose Queues via PostgREST'?
It seems to have broken in version 2.6.8

[GaryAustin1]

It was purposely turned off because it was broken and generating lots of issues.
Looks like it is being turned back on: #32753
But that has to make it thru the release cycle for the CLI.

[AmalShaiju]

Is there any ETA on when the next release will be. If not, Is there any work around that will enable me to continue with development?

[GaryAustin1]

I'm not an employee and they don't publish schedules.
I'm going to guess it was fixed in this release: https://github.com/supabase/cli/releases/tag/v2.9.8
As that bumps studio.

Supposedly you can get early access to releases with this:
npm i supabase@beta --save-dev
But I have never tried it.

[craft365]

@GaryAustin1, still Not fixed in https://github.com/supabase/cli/releases/tag/v2.9.8

[GaryAustin1]

Then file a bug report at supabase/supabase issues.
I don't do localdev so can't verify.
This is what hosted looks like now...

[johngraham262]

At least in https://github.com/supabase/cli/releases/tag/v2.12.0 , queue access via postgREST is functional for me in the local UI now.

But I'm getting a new error when trying to access the queue programmatically in local:

const { data, error } = await supabase.schema("pgmq_public").rpc("send", {
      queue_name: "q_image_generations",
      message: { hello: "world" },
    });
console.log("Error: ", error);

Prints the following error:

Error:  {
  code: 'PGRST106',
  details: null,
  hint: null,
  message: 'The schema must be one of the following: public, graphql_public'
}

Anyone else still having local queue access issues? pgmq_public should be available now, but I'm getting this error.

[GaryAustin1]

You need to add that schema to the API exposed schema settings:

[johngraham262]

Ah thank you! I was able to edit in supabase/config.toml(I don't see project settings in the local supabase console) by editing this line: schemas = ["public", "graphql_public", "pgmq_public"]

[craft365]

I can confirm. Fixed in. https://github.com/supabase/cli/releases/tag/v2.12.0