Thread: Enable/Disable Triggers
Hi All, Is it a big no-no to enable/disable triggers by manually setting pg_trigger.tgenabled to 'D'? -- Andy Chambers
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
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