Re: [GENERAL] Enable/Disable Triggers
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 DISABLE TRIGGER [ trigger_name | ALL | USER ] Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Enable/Disable Triggers
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 a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Enable/Disable Triggers
=?iso-8859-1?q?Germ=E1n_H=FCttemann_Arza?= <[EMAIL PROTECTED]> writes: > Hello, > I tried to execute ALTER TABLE emp DISABLE TRIGGER after_ins_emp on > PostgreSQL > 7.4.13 and I realised that feature isn't include yet in this version. > How can I enable/disable a trigger in this version of PostgreSQL? Update? Seriously, although the tgenabled column exists in that version, I seem to recall that it wasn't honored everywhere in the code, and there are some caching effects to worry about too. I'm afraid you'll find that changing it manually works only erratically, if at all. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] Enable/Disable Triggers
Hello, I tried to execute ALTER TABLE emp DISABLE TRIGGER after_ins_emp on PostgreSQL 7.4.13 and I realised that feature isn't include yet in this version. How can I enable/disable a trigger in this version of PostgreSQL? Should I set the attribute tgenabled from pg_trigger directly? Hope you can help me. Regards, -- Germán Hüttemann Arza CNC - Centro Nacional de Computación UNA - Universidad Nacional de Asunción Campus Universitario, San Lorenzo - Paraguay http://www.cnc.una.py - Tel.: 595 21 585550 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly