> possible:
>
> CREATE TRIGGER on_insert AFTER INSERT on emp
> FOR EACH ROW EXECUTE PROCEDURE on_ins_emp();
>
> CREATE TRIGGER on_insert AFTER INSERT on payroll
> FOR EACH ROW EXECUTE PROCEDURE on_ins_payroll();
>
> The name of the trigger is the same but the table they
> triggered for differs and they call different functions.
I think trigger names shoud be unique. Like in Informix, Oracle, DB/2.
Remember to drop a trigger, the syntax usually is:
drop trigger on_insert;
so you could safely name the function _trig_<triggername> e.g.
Andreas