Philip Warner wrote: > At 01:47 AM 12/08/2004, Tom Lane wrote: > >It might be reasonable to offer that behavior as an option, but I think > >I'd only want it on for interactive input. > > My preference would be for something like: > > set savepoint_per_statement=true > > then interactive & scripts could choose to use either feature.
Added to TODO list: * Add an option to automatically use savepoints for each statement in a multi-statement transaction. When enabled, this would allow errors in multi-statement transactions to be automatically ignored. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster