Re: Error on failed COMMIT

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: Shay Rojansky <roji(at)roji(dot)org>, Dave Cramer <davecramer(at)postgres(dot)rocks>, "Haumacher, Bernhard" <haui(at)haumacher(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Error on failed COMMIT
Date: 2020-02-24 12:29:39
Message-ID: CA+TgmoZE-GV3zYAp2JPakNe4UWzGrFTemv0Ani8aNDWXL14x=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 24, 2020 at 1:31 PM Vik Fearing <vik(at)postgresfriends(dot)org> wrote:
> On 24/02/2020 02:31, Robert Haas wrote:
> > I am really struggling to see why this is anything but a bug in the
> > JDBC driver.
>
> I can follow your logic for it being a bug in the JDBC driver, but
> "anything but"? No, this is (also) an undocumented violation of SQL.

Well, that's a fair point. I withdraw my previous statement. Instead,
I wish to argue that:

1. This problem can definitely be fixed in any given driver without
changing the behavior of the server.

2. It would be better to fix the driver than the server because this
behavior is very old and there are probably many applications (and
perhaps some drivers) that rely on it, and changing the server would
break them.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2020-02-24 12:34:28 Re: Error on failed COMMIT
Previous Message Michael Paquier 2020-02-24 12:26:42 Re: [Patch] Make pg_checksums skip foreign tablespace directories