Re: Information on savepoint requirement within transctions

On Mon, Jan 29, 2018 at 9:00 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > On Mon, Jan 29, 2018 at 8:33 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> >> What we do have though is client-side support for appropriate behaviors.
> >> In psql, see the AUTOCOMMIT and ON_ERROR_ROLLBACK control variables.
>
> > Not quite the same. I think what people probably want is for psql to
> > recognize it is in a transaction and before sending a command to the
> server
> > for processing to precede it by sending "SAVEPOINT random()". Then,
> before
> > returning the result of the command to the user issue either "RELEASE
> > SAVEPOINT" or "ROLLBACK TO SAVEPOINT" depending on whether the command
> > succeeded or failed. Then report the result to the user.
>
> Which part of that isn't implemented by ON_ERROR_ROLLBACK?
>

​My turn to fail to re-read the docs :(

David J.
​