pg_net function hooks stop working after an error

[imagitama]

Bug report

Describe the bug

Whenever any function related to pg_net fails (eg. this error #38) the extension stops trying to send any request.

It inserts the request into net.http_request_queue but nothing cares after that.

Re-enabling pg_net and recreating my triggers fixes the error.

To Reproduce

1. Enable pg_net extension
2. Create a new HTTP trigger sending a request anywhere
3. Sometimes that error I linked above occurs (cannot confirm - still investigating)
4. Cause the HTTP trigger to happen (eg. UPDATE)
5. Nothing happens

Expected behavior

Supabase recovers from the error gracefully instead of exploding and requiring me to re-enable the extension and my triggers.