Re: Error on failed COMMIT

2020-02-12 Thread Haumacher, Bernhard
Am 12.02.2020 um 00:27 schrieb Tom Lane: Vik Fearing writes: Actually, I was imagining that it would end the transaction as it does today, just with an error code. This is backed up by General Rule 9 which says "The current SQL-transaction is terminated." Hm ... that would be sensible, but I'm

Re: Error on failed COMMIT

2020-02-17 Thread Haumacher, Bernhard
Am 14.02.2020 um 20:36 schrieb Robert Haas: On Fri, Feb 14, 2020 at 2:08 PM Dave Cramer wrote: Well now you are asking the driver to re-interpret the results in a different way than the server which is not what we tend to do. The server throws an error we throw an error. We really aren't in t

Re: Error on failed COMMIT

2020-02-19 Thread Haumacher, Bernhard
Am 17.02.2020 um 23:12 schrieb Dave Cramer: On Mon, 17 Feb 2020 at 13:02, Haumacher, Bernhard <mailto:h...@haumacher.de>> wrote: ... would be an appropriate solution. PostgreSQL reports the "unsuccessful" commit through the "ROLLBACK" status code and the

Re: Error on failed COMMIT

2020-02-26 Thread Haumacher, Bernhard
Am 24.02.2020 um 13:34 schrieb Robert Haas: As I said upthread, I think one of the things that would be pretty badly broken by this is psql -f something.sql, where something.sql contains a series of blocks of the form "begin; something; something; something; commit;". Right now whichever transact