Postgres Pro
Downloads
Home   >   mailing lists

Re: Enable/Disable Triggers - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: Enable/Disable Triggers
Date
Msg-id 8447C170-AA20-4AD6-A2E6-90A21F042A2D@enterprisedb.com
Whole thread Raw
In response to Enable/Disable Triggers  ("Andy Chambers" <achambers@mcna.net>)
List pgsql-general
Tree view 
On Mar 16, 2011, at 2:31 AM, Andy Chambers wrote:

> Is it a big no-no to enable/disable triggers by manually setting pg_trigger.tgenabled to 'D'?



Not recommended to do anything with catalog tables. At the place of this use following command:
ALTER TABLE <tablename> DISABLE TRIGGER [ trigger_name | ALL | USER ]

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Enable/Disable Triggers
Next
From: Alexander Farber
Date:
Subject: Re: Copying data from one table to another - how to specify fields?