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

From Andrew Sullivan
Subject Re: Enable/Disable Triggers
Date
Msg-id 20110315213342.GE76699@shinkuro.com
Whole thread Raw
In response to Enable/Disable Triggers  ("Andy Chambers" <achambers@mcna.net>)
List pgsql-general
On Tue, Mar 15, 2011 at 05:01:50PM -0400, Andy Chambers wrote:
> Is it a big no-no to enable/disable triggers by manually setting
> pg_trigger.tgenabled to 'D'?

No, but I seem to recall having seen corner cases where it didn't
work.  (This was the reason that in older versions of slony, slony
fooled with the system catalogues instead.)

You can use the replication_role control to prevent triggers firing.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: A join of 2 tables with sum(column) > 30
Next
From: Vibhor Kumar
Date:
Subject: Re: Enable/Disable Triggers