Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, robertmhaas@gmail.com, christoph.berg@credativ.de, pgsql-bugs@lists.postgresql.org
Date: 2022-06-14T01:31:21Z
Lists: pgsql-bugs
On Mon, Jun 13, 2022 at 10:52:16AM -0400, Tom Lane wrote:
> I think it's fine to commit this to HEAD.  The reason for reverting
> in the back branches was exactly that we'd already changed the behavior;
> and what we now see is that it's still buggy and we need to change it
> some more.  That's an entirely appropriate thing to be doing in beta.

Okay, let's do so then on HEAD.  I'll wait a bit more, in case others
have an opinion to offer on the matter.
--
Michael

Commits

  1. Tweak behavior of psql --single-transaction depending on ON_ERROR_STOP

  2. Doc: remove a04ccf6df from release notes, now that it's reverted.

  3. Revert "Fix psql's single transaction mode on client-side errors with -c/-f switches".

  4. Fix psql's single transaction mode on client-side errors with -c/-f switches