can't create functions in a specific schema in the free tier but works in paid tier
to repro
CREATE OR REPLACE FUNCTION "udbhav-sift-dev".ticket_created() RETURNS TRIGGER AS $$
BEGIN
PERFORM pg_notify('ticket_created_channel', NEW.id);
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
if you run this you will see that no functions get created in the specified schema , in my case it was 'udbhav-sift-dev'
to check if functions are created run the command
\df3 Replies
xenogeneic-maroon•16mo ago
Hmm, it worked for me
xenogeneic-maroon•16mo ago
I did it on the public schema though
xenogeneic-maroon•16mo ago
Are you getting any errors?