How do we call a RPC function or Edge Function from another RPC cron function?

[PoojaB26]

Trying to call an Edge Function from a RPC function's cron.job call, tried this:

CREATE OR REPLACE FUNCTION schedule_user_notification(
    user_id UUID, 
    notify_time TIMETZ
)
RETURNS VOID AS $$
DECLARE
    job_name TEXT;
    utc_time TIMETZ;
BEGIN
.....///
    PERFORM cron.schedule(
        job_name,
        CONCAT(
            EXTRACT(MINUTE FROM utc_time), ' ',
            EXTRACT(HOUR FROM utc_time), ' * * *'
        ),
        FORMAT($$
            SELECT http_get('https://your-project.functions.supabase.co/send-notifications?user_id=%s') <--- not allowed
        $$, user_id)
    );
END;
$$ LANGUAGE plpgsql;

But calling SELECT was not allowed apparently. I converted the edge function call into another RPC call which worked but I cant call that RPC function from my RPC function still because of SELECT keyword I think.

FORMAT($$
            SELECT send_user_notification('%s')
        $$, user_id)```
        
  How can we solve this? 

[GaryAustin1]

If you are not handling return data then you would use PERFORM instead of SELECT.

[PoojaB26]

PERFORM is also not allowed, I tried that too.

[GaryAustin1]

There is a current issue with pg_net (.8 version) and a permission error.
You are not showing error codes so not clear what you are hitting.

Also this https://supabase.com/docs/guides/cron/quickstart#invoke-supabase-edge-function-every-30-seconds shows a typical call to pg_net