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@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
