How to create trigger if it does not exist - Mailing list pgsql-general

From Andrus
Subject How to create trigger if it does not exist
Date
Msg-id f39vd0$1lr5$1@news.hub.org
Whole thread Raw
List pgsql-general
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.



pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: Delete with subquery deleting all records
Next
From: Justin M Wozniak
Date:
Subject: Possible DB corruption