Supabase•7mo ago•

8 replies

Grant EXECUTE Permission on public.http_request Function

Hey Supabase Admin,

I'm still stuck on a very persistent issue with my project (ID: nemluxhhfwegfpffpike).

Problem:
When I try to create a database trigger, it fails with:

ERROR: 42883: function public.http_request() does not exist

ERROR: 42883: function public.http_request() does not exist

What I've done (and confirmed):
1.

pg_net

pg_net

extension is enabled and confirmed to be installed in the

net

net

schema.
2. I've successfully run the SQL to

CREATE OR REPLACE FUNCTION public.http_request(...)

CREATE OR REPLACE FUNCTION public.http_request(...)

which internally calls

net.http_post

net.http_post

net.http_get

net.http_get

. This step shows "Success. No rows returned".
3. I've successfully run

GRANT EXECUTE ON FUNCTION public.http_request(text, text, jsonb, text, int) TO postgres;

GRANT EXECUTE ON FUNCTION public.http_request(text, text, jsonb, text, int) TO postgres;

to grant permissions.
4. I'm running each step in fresh SQL Editor tabs.

Despite

public.http_request

public.http_request

appearing to be created and permissions granted, the trigger still can't find it. It's behaving as if the function isn't visible to the

postgres

postgres

role or the trigger's context.

Could you please help investigate this? It feels like a deeper database state or visibility issue.

Thanks!

Grant EXECUTE Permission on public.http_request Function

Hey Supabase Admin,

I'm still stuck on a very persistent issue with my project (ID: nemluxhhfwegfpffpike).

Problem:
When I try to create a database trigger, it fails with:

ERROR: 42883: function public.http_request() does not exist

ERROR: 42883: function public.http_request() does not exist

What I've done (and confirmed):
1.

pg_net

pg_net

extension is enabled and confirmed to be installed in the

net

net

schema.
2. I've successfully run the SQL to

CREATE OR REPLACE FUNCTION public.http_request(...)

CREATE OR REPLACE FUNCTION public.http_request(...)

which internally calls

net.http_post

net.http_post

net.http_get

net.http_get

. This step shows "Success. No rows returned".
3. I've successfully run

GRANT EXECUTE ON FUNCTION public.http_request(text, text, jsonb, text, int) TO postgres;

GRANT EXECUTE ON FUNCTION public.http_request(text, text, jsonb, text, int) TO postgres;

to grant permissions.
4. I'm running each step in fresh SQL Editor tabs.

Despite

public.http_request

public.http_request

appearing to be created and permissions granted, the trigger still can't find it. It's behaving as if the function isn't visible to the

postgres

postgres

role or the trigger's context.

Could you please help investigate this? It feels like a deeper database state or visibility issue.

Thanks!

Grant EXECUTE Permission on public.http_request Function

Similar Threads

Grant EXECUTE Permission on public.http_request Function

Similar Threads

Similar Threads

Similar Threads