Re: Atomic operations? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Atomic operations?
Date
Msg-id Pine.BSO.4.64.0803192335220.29669@leary.csoft.net
Whole thread Raw
In response to Re: Atomic operations?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc

On Wed, 19 Mar 2008, Dave Cramer wrote:

>
> On 18-Mar-08, at 7:18 PM, Oliver Jowett wrote:
>
>> Actually it's fine the implicit transaction created by the server to
>> support autocommit wraps both queries in a single transaction and does not
>> commit/rollback until the end of the second query.
>>
> Yeah, using v3 protocol this is presented as one prepare/execute. Thanks for
> catching that.

For the record, v2 sends both statements in a single query message
grouping them in the same transaction.  v3 sends a prepare and execute for
each statement (as required by the extended query protocol), but the
transaction is demarcated by the Sync message and there's only one of
those.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC rewriting a bad query?
Next
From: Craig Ringer
Date:
Subject: Non-ORM layers over JDBC