Re: Disabling triggers in a transaction

This caught my eye the other day, but didn't take the time to examine it. I
find that I am now very interested in it. Could you please elaborate on your
method and how this works?

TIA

On Sunday 27 February 2005 05:37 pm, Jay Guerette saith:
> 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? So an INSERT or UPDATE to this
> table, outside of the transaction and within that precise timeframe,
> would NOT fire the trigger? If so, would the 'serializable ' isolation
> level be required in order to ensure this doesn't happen?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match