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

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

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

What I've done (and confirmed):

```
pg_net
```
pg_net
```
pg_net
```
pg_net
extension is enabled and confirmed to be installed in the
```
net
```
net
```
net
```
net
schema.
I've successfully run the SQL to
```
CREATE OR REPLACE FUNCTION public.http_request(...)
```
CREATE OR REPLACE FUNCTION public.http_request(...)
```
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_post
```
net.http_post
/
```
net.http_get
```
net.http_get
```
net.http_get
```
net.http_get
. This step shows "Success. No rows returned".
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;
```
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.
I'm running each step in fresh SQL Editor tabs.

Despite

public.http_request

public.http_request

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

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

Similar Threads

Similar Threads