@@ -551,3 +551,64 @@ Gavin
551551---------------------------(end of broadcast)---------------------------
552552TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
553553
554+ From pgsql-general-owner+M33538@postgresql.org Tue Nov 26 03:46:45 2002
555+ Return-path: <pgsql-general-owner+M33538@postgresql.org>
556+ Received: from postgresql.org (postgresql.org [64.49.215.8])
557+ by candle.pha.pa.us (8.11.6/8.10.1) with ESMTP id gAQ8kio01351
558+ for <pgman@candle.pha.pa.us>; Tue, 26 Nov 2002 03:46:44 -0500 (EST)
559+ Received: from localhost (postgresql.org [64.49.215.8])
560+ by postgresql.org (Postfix) with ESMTP
561+ id 8EB404760F9; Tue, 26 Nov 2002 03:46:13 -0500 (EST)
562+ Received: from postgresql.org (postgresql.org [64.49.215.8])
563+ by postgresql.org (Postfix) with SMTP
564+ id B1942475FCE; Tue, 26 Nov 2002 03:46:06 -0500 (EST)
565+ Received: from localhost (postgresql.org [64.49.215.8])
566+ by postgresql.org (Postfix) with ESMTP id 950CD474E53
567+ for <pgsql-general@postgresql.org>; Tue, 26 Nov 2002 03:45:30 -0500 (EST)
568+ Received: from hera.hs-niederrhein.de (hera.hs-niederrhein.de [194.94.120.3])
569+ by postgresql.org (Postfix) with ESMTP id 4E172474E44
570+ for <pgsql-general@postgresql.org>; Tue, 26 Nov 2002 03:45:29 -0500 (EST)
571+ Received: (from root@localhost)
572+ by hera.hs-niederrhein.de (8.11.6+Sun/8.11.6) id gAQ8jTK27063
573+ for pgsql-general@postgresql.org; Tue, 26 Nov 2002 09:45:29 +0100 (CET)
574+ Received: from terra (31-094.hs-niederrhein.de [193.175.48.94])
575+ by hera.hs-niederrhein.de (8.11.6+Sun/8.11.6) with SMTP id gAQ8jPP27051
576+ for <pgsql-general@postgresql.org>; Tue, 26 Nov 2002 09:45:25 +0100 (CET)
577+ Date: Tue, 26 Nov 2002 09:43:32 +0100
578+ From: Christoph Dalitz <christoph.dalitz@hs-niederrhein.de>
579+ To: pgsql-general@postgresql.org
580+ Subject: [GENERAL] ALTER TRIGGER DISABLE/ENABLE
581+ Message-ID: <20021126094332.58250aef.christoph.dalitz@hs-niederrhein.de>
582+ X-Mailer: Sylpheed version 0.6.6 (GTK+ 1.2.8; i586-pc-linux-gnu)
583+ MIME-Version: 1.0
584+ Content-Type: text/plain; charset=US-ASCII
585+ Content-Transfer-Encoding: 7bit
586+ X-Virus-Scanned: by AMaViS perl-11
587+ X-Virus-Scanned: by AMaViS new-20020517
588+ Precedence: bulk
589+ Sender: pgsql-general-owner@postgresql.org
590+ X-Virus-Scanned: by AMaViS new-20020517
591+ Status: ORr
592+
593+ Hello,
594+
595+ while there have been suggested some hacks on the system catalog
596+ for disabling/enabling triggers, these have two serious disadvantages:
597+
598+ - they cannot be done by the owner of the trigger
599+ (only the DBA has write access to the system catalog)
600+ - messing in the system catalog for simple DB schema changes makes
601+ most users feel uneasy
602+
603+ Oracle has an SQL command "ALTER TRIGGER triggername DISABLE|ENABLE".
604+ Were it possible to put this command on the TODO list for a future PG release?
605+
606+ Thanks,
607+
608+ Christoph Dalitz
609+
610+ ---------------------------(end of broadcast)---------------------------
611+ TIP 6: Have you searched our list archives?
612+
613+ http://archives.postgresql.org
614+