Re: How to create trigger if it does not exist

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to create trigger if it does not exist
Date: 2007-05-28 17:14:55
Message-ID: f3f2pc$1vaj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Rodrigo De Len" <rdeleonp(at)gmail(dot)com> kirjutas snumis
news:1180317464(dot)302359(dot)95000(at)k79g2000hse(dot)googlegroups(dot)com(dot)(dot)(dot)
> On May 26, 5:58 pm, "Andrus" <kobrule(dot)(dot)(dot)(at)hot(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Quinn 2007-05-28 17:18:47 Re: createdb.exe prompting for password on Vista
Previous Message Poul Møller Hansen 2007-05-28 17:07:41 Different sort order