Re: ALTER TRIGGER DISABLE/ENABLE

Christoph Dalitz wrote:
> 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?

Already on TODO list:

* Allow triggers to be disabled [trigger]

I will add your email to the TODO.detail thread.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073