[GENERAL] How to create trigger if it does not exist

[Andrus]

CREATE TRIGGER mycheck_trigger BEFORE INSERT OR UPDATE ON mytbl
    FOR EACH ROW EXECUTE PROCEDURE mycheck_pkey();

aborts transaction if trigger already exists.

There in no CREATE OR REPLACE TRIGGER command in PostgreSQL

How to create trigger only when it does not exist ?

Andrus. 



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly