@@ -612,3 +612,72 @@ TIP 6: Have you searched our list archives?
612612
613613http://archives.postgresql.org
614614
615+ From jllachan@nsd.ca Tue Nov 26 14:42:05 2002
616+ Return-path: <jllachan@nsd.ca>
617+ Received: from beamish.nsd.ca (IDENT:root@[205.150.156.194])
618+ by candle.pha.pa.us (8.11.6/8.10.1) with ESMTP id gAQJg2P06491
619+ for <pgman@candle.pha.pa.us>; Tue, 26 Nov 2002 14:42:04 -0500 (EST)
620+ Received: (from smap@localhost)
621+ by beamish.nsd.ca (8.9.3/8.9.3) id OAA28217;
622+ Tue, 26 Nov 2002 14:41:56 -0500
623+ X-Authentication-Warning: beamish.nsd.ca: smap set sender to <jllachan@nsd.ca> using -f
624+ Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam)
625+ id xma028213; Tue, 26 Nov 02 14:41:31 -0500
626+ Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148])
627+ by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id OAA22894;
628+ Tue, 26 Nov 2002 14:40:22 -0500
629+ Sender: jllachan@reddog.nsd.ca
630+ Message-ID: <3DE3CE7B.614EE99E@nsd.ca>
631+ Date: Tue, 26 Nov 2002 14:41:47 -0500
632+ From: Jean-Luc Lachance <jllachan@nsd.ca>
633+ X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686)
634+ X-Accept-Language: en
635+ MIME-Version: 1.0
636+ To: Bruce Momjian <pgman@candle.pha.pa.us>
637+ cc: Christoph Dalitz <christoph.dalitz@hs-niederrhein.de>,
638+ pgsql-general@postgresql.org
639+ Subject: Re: [GENERAL] ALTER TRIGGER DISABLE/ENABLE
640+ References: <200211261853.gAQIrdE00304@candle.pha.pa.us>
641+ Content-Type: text/plain; charset=us-ascii
642+ Content-Transfer-Encoding: 7bit
643+ Status: OR
644+
645+ I think thte sintax should be:
646+
647+ ALTER TABLE DISABLE|ENABLE TRIGGER {trigger name}|ALL
648+
649+
650+
651+ Bruce Momjian wrote:
652+ >
653+ > Christoph Dalitz wrote:
654+ > > Hello,
655+ > >
656+ > > while there have been suggested some hacks on the system catalog
657+ > > for disabling/enabling triggers, these have two serious disadvantages:
658+ > >
659+ > > - they cannot be done by the owner of the trigger
660+ > > (only the DBA has write access to the system catalog)
661+ > > - messing in the system catalog for simple DB schema changes makes
662+ > > most users feel uneasy
663+ > >
664+ > > Oracle has an SQL command "ALTER TRIGGER triggername DISABLE|ENABLE".
665+ > > Were it possible to put this command on the TODO list for a future PG release?
666+ >
667+ > Already on TODO list:
668+ >
669+ > * Allow triggers to be disabled [trigger]
670+ >
671+ > I will add your email to the TODO.detail thread.
672+ >
673+ > --
674+ > Bruce Momjian | http://candle.pha.pa.us
675+ > pgman@candle.pha.pa.us | (610) 359-1001
676+ > + If your life is a hard drive, | 13 Roberts Road
677+ > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
678+ >
679+ > ---------------------------(end of broadcast)---------------------------
680+ > TIP 6: Have you searched our list archives?
681+ >
682+ > http://archives.postgresql.org
683+