Re: jdbc xa support - Mailing list pgsql-jdbc

From Michael Allman
Subject Re: jdbc xa support
Date
Msg-id 20050724002628.H55910@yvyyl
Whole thread Raw
In response to Re: jdbc xa support  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-jdbc
On Sun, 24 Jul 2005, Heikki Linnakangas wrote:

> On Sat, 23 Jul 2005, Michael Allman wrote:
>
>> On a related note, can we get the backend to indicate if a transaction was
>> read-only when the "PREPARE TRANSACTION" statement is called?  (Also, I
>> believe preparing a read-only transaction should automatically "commit"
>> it.) We could then return XA_RDONLY from the driver's prepare() method in
>> that case.  As it is, it either throws an exception or returns XA_OK.
>
> It should be possible, but we're already past the feature freeze so it'll
> have to wait for version 8.2. The backend already keeps track which
> transactions are read-only, and skips updating the clog for them. That
> information just needs to be exposed.

Cool.  It would be a nice optimization to incorporate in the driver when
it becomes available in the backend.

Michael

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: jdbc xa support
Next
From: "emergency.shower@gmail.com"
Date:
Subject: Timestamp weirdness