DB Trigger Error: schema "supabase_functions" does not exist when invoking Edge Function #36206
Unanswered
TMtechnologyprj
asked this question in
Questions
Replies: 1 comment
|
Do you have Webhooks enabled? That schema is part of webhooks. |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Hello, Supabase community,
I'm facing a critical issue when trying to invoke an Edge Function from a PostgreSQL database trigger, and I'm hoping someone might have some insight.
The Goal:
I have an Edge Function named trigger-n8n-onboarding deployed successfully. The goal is to have a PostgreSQL trigger on my public.profiles table call this function AFTER UPDATE, specifically when a user completes their onboarding (onboarding_completed_at column is set).
The Problem:
When the trigger fires, it executes a PostgreSQL function that attempts to call supabase_functions.invoke(...). This call fails, and my PostgreSQL logs show the following warning (captured from my EXCEPTION block):
WARNING: [KODEX_FIT_TRIGGER] ERRO ao invocar Edge Function: SQLSTATE: 3F000, MESSAGE: schema "supabase_functions" does not exist
Troubleshooting Steps I've Already Taken:
It seems to be a project provisioning issue where the internal supabase_functions schema, necessary for this interaction, is not present.
Has anyone encountered this before? Is there any other step I can take to try and force a reprovisioning of this internal schema? I'm happy to provide my Project ID to a Supabase team member through a secure channel if needed.
Thank you!
All reactions