Supabase Webhook causes ‘permission denied for schema net’ error
Hi! I created a Database Webhook that triggers an Edge Function whenever a new row is inserted/updated into a table.
The Edge Function then calls a 3rd-party API to send telegram notification
However, after creating the webhook, inserting into the table throws this error:
Error:
I’m using pg_net version 0.7.1 and PostgreSQL version 15.1.1.3, and I’ve been dealing with this issue for about a week...
Any help would be greatly appreciated
The Edge Function then calls a 3rd-party API to send telegram notification
However, after creating the webhook, inserting into the table throws this error:
Error:
Failed to run sql query: ERROR: 42501: permission denied for schema net QUERY: SELECT http_post FROM net.http_post( url, payload, params, headers, timeout_ms ) CONTEXT: PL/pgSQL function http_request() line 54 at SQL statementI’m using pg_net version 0.7.1 and PostgreSQL version 15.1.1.3, and I’ve been dealing with this issue for about a week...
Any help would be greatly appreciated
