Re: Enable/Disable Triggers

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Enable/Disable Triggers
Date: 2011-03-15 21:33:43
Message-ID: 20110315213342.GE76699@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-15 21:36:49 Re: Enable/Disable Triggers
Previous Message Alexander Farber 2011-03-15 21:33:12 A join of 2 tables with sum(column) > 30