Re: Disabling triggers in a transaction - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Disabling triggers in a transaction
Date
Msg-id 200503090405.j2945Cr18288@candle.pha.pa.us
Whole thread Raw
In response to Re: Disabling triggers in a transaction  (Geoffrey <esoteric@3times25.net>)
Responses Re: Disabling triggers in a transaction  (Adam Tomjack <adamtj@adamtj.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL still for Linux only?
Next
From: Robby Russell
Date:
Subject: Re: PostgreSQL still for Linux only?