Skip site navigation (1) Skip section navigation (2)

Re: Re: One transaction by connection - commit subdetails without release master transaction?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Durumdara <durumdara(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: One transaction by connection - commit subdetails without release master transaction?
Date: 2012-02-29 23:13:13
Message-ID: 0B09890A-8685-423E-8E82-04D5AAC59B19@silentmedia.com (view raw or flat)
Thread:
Lists: pgsql-general
On Feb 29, 2012, at 3:00 PM, Alban Hertroys wrote:

> On 29 Feb 2012, at 20:44, Ben Chobot wrote:
> 
>>> As I see the PGSQL supports one transaction per connection. Is this
>>> information ok?
>> 
>> Yes, in postgres a connection can support only one transaction.
> 
> 
> A small correction: a connection can support only one transaction _simultaneously_. You can serialise transactions on one connection just fine.

Heh, woops, yes, that's a good correction to make. :)


In response to

pgsql-general by date

Next:From: Tim WilsonDate: 2012-02-29 23:38:35
Subject: Re: PickSplit method of 2 columns ... error
Previous:From: Alban HertroysDate: 2012-02-29 23:00:30
Subject: Re: Re: One transaction by connection - commit subdetails without release master transaction?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group