Re: Does psql use nested transactions?

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > 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.
> 
> Note that whoever implements this had better be mindful of the bad
> experience we had with autocommit.  If there is any way that this
> behavior could be turned on underneath an application/script without
> the app knowing about it, this would be spectacularly dangerous.
> 
> Like I said, my preference would be that it couldn't be turned on at all
> except when psql's input is interactive.

Should we allow it only to be enabled inside a multi-statement
transaction, and it turns off when the transaction completes?

Doing it only for interactive mode seems too error-prone to me (it works
in psql, but not from my script).

--  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