Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: One transaction by connection - commit subdetails without release master transaction? - Mailing list pgsql-general

From Ben Chobot
Subject Re: Re: One transaction by connection - commit subdetails without release master transaction?
Date
Msg-id 2D3BC8E5-9BA4-473D-AE99-D03D2325BF09@silentmedia.com
Whole thread Raw
In response to Re: One transaction by connection - commit subdetails without release master transaction?  (Durumdara <durumdara@gmail.com>)
Responses Re: Re: One transaction by connection - commit subdetails without release master transaction?
List pgsql-general
Tree view 
On Feb 29, 2012, at 4:11 AM, Durumdara wrote:

> Dear Anybody!
>
> I replace the long question to some shorter:
>
> As I see the PGSQL supports one transaction per connection. Is this
> information ok?

Yes, in postgres a connection can support only one transaction.

If you wish to reduce the number of connections, look into a connection pooler, such as pgBouncer.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Privilege on schema 'public' not revokable
Next
From: Rich Shepard
Date:
Subject: Re: Valid Input Syntax for Type DATE