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 f3ae3q$2m17$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>)
List 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.



pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to create trigger if it does not exist
Next
From: olivier
Date:
Subject: hundreds of schema vs hundreds of databases