Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrus
Subject Re: How to create trigger if it does not exist
Date
Msg-id f3f2pc$1vaj$1@news.hub.org
Whole thread Raw
In response to Re: How to create trigger if it does not exist  (Rodrigo De León <rdeleonp@gmail.com>)
Responses Re: How to create trigger if it does not exist
List pgsql-general
Tree view 
"Rodrigo De Le�n" <rdeleonp@gmail.com> kirjutas s�numis
news:1180317464.302359.95000@k79g2000hse.googlegroups.com...
> On May 26, 5:58 pm, "Andrus" <kobrule...@hot.ee> wrote:
>> Thank you.
>> This doc says that dropping trigger drops depending objects also.
>
> Only if you use CASCADE (default is RESTRICT).
>

If I do not use CASCADE deleting trigger fail if there are objects which
depend on trigger.
So I MUST use cascase.

Andrs.

pgsql-general by date:

Previous
From: "Kimball Bighorse"
Date:
Subject:
Next
From: "Andrus"
Date:
Subject: Re: How to create trigger if it does not exist