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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073