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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend