Re: Does psql use nested transactions?

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073