Hi, is it possible to use http_get in a trigger fu...
# help
c
Hi, is it possible to use http_get in a trigger function? I can't get it working. thanks
n
Hello @coinmaster47! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
s
You should be able to. Are you getting any error message?
n
coinmaster47 (2022-06-05)
c
I'm getting {"code":500,"msg":"Database error saving new user","error_id":"xxx"} when trying to create a new user trigger.
My trigger function:
begin SET search_path =extensions, security, public, pg_temp; SELECT status FROM http_get('https://xxxx); return null; end;
Trigger on user new
Is trigger to monitor new table a big bugger or is it just me?
s
I don't understand this question
c
Sorry about that. My question does the below trigger work for you:
begin SET search_path =extensions, security, public, pg_temp; SELECT status FROM http_get('https://xxxx/); return null; end;
trigger this on new user
any url will do