From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
Cc: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: JDBC behaviour |
Date: | 2016-02-20 11:02:29 |
Message-ID: | CAMsr+YFAr0SPOBr4NXLPnXFnP649t4Ch0qZ7PXJryWis9RLAPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-jdbc |
On 18 February 2016 at 16:13, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com
> wrote:
If you want to shoot yourself in a foot for fun and profit, you can
> try https://github.com/pgjdbc/pgjdbc/pull/477.
>
I think this should be incorporated, once it's ready, as a non-default
connection option. It's handy for porting applications.
I think PostgreSQL's behaviour is the most correct, but if people are
porting apps and want to wear the performance impact of all those
savepoints and have written their code to handle partially-failed xacts,
then sure, they can have that.
I'm constantly astounded by how many people are willing to simply ignore
errors and carry on with the transaction without even properly verifying
that the error was the exact one they expected though. Seriously bad
application development and it *will* bite them. The best, most correct
thing to do remains to retry the whole transaction.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-02-20 11:05:35 | Re: JDBC behaviour |
Previous Message | Craig Ringer | 2016-02-20 10:56:57 | Re: JDBC behaviour |
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-02-20 11:05:35 | Re: JDBC behaviour |
Previous Message | Craig Ringer | 2016-02-20 10:56:57 | Re: JDBC behaviour |
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-02-20 11:05:35 | Re: JDBC behaviour |
Previous Message | Craig Ringer | 2016-02-20 10:56:57 | Re: JDBC behaviour |