Re: JDBC behaviour

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: JDBC behaviour
Дата
Msg-id CAMsr+YFAr0SPOBr4NXLPnXFnP649t4Ch0qZ7PXJryWis9RLAPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JDBC behaviour  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список pgsql-jdbc
On 18 February 2016 at 16:13, Vladimir Sitnikov <sitnikov.vladimir@gmail.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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: JDBC behaviour
Следующее
От: John R Pierce
Дата:
Сообщение: Re: JDBC behaviour