Postgres Pro
Downloads
Home   >   mailing lists

Re: Error on failed COMMIT - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: Error on failed COMMIT
Date
Msg-id CADK3HH+oT8xXJ63BsQPsG+ZLUO7wc2UrWh31ty7J=36qNswxig@mail.gmail.com
Whole thread Raw
In response to Re: Error on failed COMMIT  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Error on failed COMMIT  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view


On Fri, 14 Feb 2020 at 15:19, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
On 2020-Feb-14, Dave Cramer wrote:

> I offered to make the behaviour in the JDBC driver dependent on a
> configuration parameter

Do you mean "if con.commit() results in a rollback, then an exception is
thrown, unless the parameter XYZ is set to PQR"?


No. JDBC has a number of connection parameters which change internal semantics of various things.

I was proposing to have a connection parameter which would be throwExceptionOnFailedCommit (or something) which would do what it says.

None of this would touch the server. It would just change the driver semantics.


Dave Cramer
www.postgres.rocks
 

pgsql-hackers by date:

Previous
From: Soumyadeep Chakraborty
Date:
Subject: Re: Zedstore - compressed in-core columnar storage
Next
From: Tom Lane
Date:
Subject: Standards compliance of SET ROLE / SET SESSION AUTHORIZATION