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-26 22:58:19
Message-ID: f3ae3q$2m17$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> How to create trigger only when it does not exist ?

> DROP TRIGGER IF EXISTS...
>
> See:
>
> http://www.postgresql.org/docs/8.2/static/sql-droptrigger.html

Thank you.
This doc says that dropping trigger drops depending objects also.

Which objects depend on the user-defined trigger so that they are also
dropped ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2007-05-27 02:06:11 Re: backup strategies
Previous Message Rodrigo De León 2007-05-26 20:22:44 Re: How to create trigger if it does not exist