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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend