Обсуждение: How to create trigger if it does not exist

Поиск
Список
Период
Сортировка

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.