Search Postgresql Archives

Re: Disabling triggers in a transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx               |  (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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux