ALTER TRIGGER DISABLE/ENABLE - Mailing list pgsql-general

From Christoph Dalitz
Subject ALTER TRIGGER DISABLE/ENABLE
Date
Msg-id 20021126094332.58250aef.christoph.dalitz@hs-niederrhein.de
Whole thread Raw
Responses Re: ALTER TRIGGER DISABLE/ENABLE
Re: ALTER TRIGGER DISABLE/ENABLE
List pgsql-general
Hello,

while there have been suggested some hacks on the system catalog
for disabling/enabling triggers, these have two serious disadvantages:

 - they cannot be done by the owner of the trigger
   (only the DBA has write access to the system catalog)
 - messing in the system catalog for simple DB schema changes makes
   most users feel uneasy

Oracle has an SQL command "ALTER TRIGGER triggername DISABLE|ENABLE".
Were it possible to put this command on the TODO list for a future PG release?

Thanks,

Christoph Dalitz

pgsql-general by date:

Previous
From: "SUFFIAN RAMLI"
Date:
Subject: Bytea datatype insert to PostgreSQL DBase
Next
From: Tina Messmann
Date:
Subject: Re: vacuum strategy