Re: disable a single trigger - Mailing list pgsql-hackers

From Tom Lane
Subject Re: disable a single trigger
Date
Msg-id 1052.1036442769@sss.pgh.pa.us
Whole thread Raw
In response to disable a single trigger  (Laurette Cisneros <laurette@nextbus.com>)
List pgsql-hackers
Laurette Cisneros <laurette@nextbus.com> writes:
> What is the status of the tgenabled field in pg_trigger?  It would be so
> nice to be able to disable just a single trigger on a table rather than
> having to disable all triggers.  The docs say "not presently checked
> everywhere it should be, so disabling a trigger by setting this false 
> does not work reliably". 

I believe it does work for BEFORE triggers, but not AFTER triggers.
There was some question about when it should be checked for an AFTER
trigger (when the event is queued?  Or fired?).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is my Internet connection slow
Next
From: Bruce Momjian
Date:
Subject: Re: Is my Internet connection slow