[HACKERS] disable a single trigger

[Laurette Cisneros]

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. 

Will it ever be reliable?

Thanks,

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
--
My other vehicle is my imagination.
 - bumper sticker


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] disable a single trigger

[Tom Lane]

Laurette Cisneros [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly