I presume threre is a query which check for the function/trigger
existence? Something like:
IF NOT EXIST(SELECT * FROM ) CREATE OR REPLACE FUNCTION....;
CREATE OR REPLACE is how you re-create a function that (whose name/signature) might already exist; CREATE already assumes one doesn't exist.
David J.
