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

From: Christoph Berg <christoph(dot)berg(at)credativ(dot)de>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
Date: 2022-05-30 15:18:28
Message-ID: YpTgRGknCLBopP8C@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Re: PG Bug reporting form
> The problem is not limited to \copy; \i has the same problem.
> A workaround is to drop -1, and use an explicit transaction in the script.

\connect correctly aborts the whole operation.

I would suggest that all client-side errors should be handled as fatal
when both --single-transaction and -vON_ERROR_STOP=1 are in effect.

Christoph

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2022-05-30 16:36:05 Re: BUG #17449: Disk space not released
Previous Message PG Bug reporting form 2022-05-30 14:59:24 BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error