Can cron-scheduled functions interact with DB?
I saw this example: https://supabase.com/docs/guides/functions/schedule-functions
It shows how to use pg_cron to schedule the call of an edge function.
My question is: Can a function triggered from the db also open its own db connection to interact with the DB, or would it not work because of re-entrancy? (DB calling the function which tries to access the DB)
It shows how to use pg_cron to schedule the call of an edge function.
My question is: Can a function triggered from the db also open its own db connection to interact with the DB, or would it not work because of re-entrancy? (DB calling the function which tries to access the DB)
