Re: Disabling triggers in a transaction

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?

TIA

On Monday 28 February 2005 03:22 pm, Tom Lane saith:
> Jay Guerette <jayguerette(at)gmail(dot)com> writes:
> > If I disable INSERT and UPDATE triggers inside a transaction; by
> > setting and resetting reltriggers in pg_class; am I correct in
> > thinking that this will disable triggers globally for that table for
> > the duration of that transaction?
>
> Not if you never commit the pg_class row in that state.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings