Re: Does psql use nested transactions? - Mailing list pgsql-hackers

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 pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073