Search Postgresql Archives

Re: Enable/Disable Triggers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux