Re: Disabling triggers in a transaction

Geoffrey wrote:
> Terry Lee Tucker wrote:
> > Tom,
> >
> > Do you feel this is a safe method for disabling triggers in the rare cases
> > where one finds that it is prudent to do that? Do you think that the column,
> > "reltriggers", is permanent fixture in pg_class? What is your advice on this?
>
> I'd be quite interested in this as well. Can one depend on this column
> in the future? Even if not, as long as one verifies it still exists, is
> this a viable option for trigger control within a transaction?
>
> (This guy Tucker comes up with some interesting stuff...) :)

It is the only known way to control triggers though it isn't regularly
tested by the developers.

--
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