Re: Atomic operations?

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Atomic operations?
Дата
Msg-id Pine.BSO.4.64.0803192335220.29669@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Atomic operations?  (Dave Cramer <pg@fastcrypt.com>)
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: JDBC rewriting a bad query?
Следующее
От: Craig Ringer
Дата:
Сообщение: Non-ORM layers over JDBC