Re: Enable/Disable Triggers

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: achambers(at)mcna(dot)net
Cc: "Postgresql (General)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Enable/Disable Triggers
Date: 2011-03-15 21:36:49
Message-ID: 8447C170-AA20-4AD6-A2E6-90A21F042A2D@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-03-15 21:40:34 Re: Copying data from one table to another - how to specify fields?
Previous Message Andrew Sullivan 2011-03-15 21:33:43 Re: Enable/Disable Triggers