multiple procedure call in a trigger? multiple procedure call in a trigger? postgresql postgresql

multiple procedure call in a trigger?


As commented, creating a trigger per procedure is one way. I think you could also just wrap the function calls to one procedure, like (psql example):

CREATE OR REPLACE FUNCTION do_notifies() RETURNS VOID AS $$BEGIN    PERFORM notify_events();    PERFORM notify_events_count();END; $$LANGUAGE plpgsql;

and in your trigger just:

EXECUTE PROCEDURE public.do_notifies();