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

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: One transaction by connection - commit subdetails without release master transaction?
Date: 2012-02-29 19:44:10
Message-ID: 2D3BC8E5-9BA4-473D-AE99-D03D2325BF09@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2012-02-29 21:42:09 Re: Valid Input Syntax for Type DATE
Previous Message Tom Lane 2012-02-29 19:14:19 Re: Privilege on schema 'public' not revokable