Postgres Pro
Downloads
Home   >   mailing lists

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

From Christoph Berg
Subject Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
Date
Msg-id YpTgRGknCLBopP8C@msg.df7cb.de
Whole thread Raw
In response to BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
Next
From: Jeff Janes
Date:
Subject: Re: BUG #17449: Disk space not released