Re: begin transaction locks out other connections

From: "Dennis Brakhane" <brakhane(at)googlemail(dot)com>
To: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
Cc: "Ivano Luberti" <luberti(at)archicoop(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: begin transaction locks out other connections
Date: 2008-04-10 17:59:53
Message-ID: 226a19190804101059s2363c95dx4fad42ca15c2f186@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 10, 2008 at 4:40 PM, Pavan Deolasee
<pavan(dot)deolasee(at)gmail(dot)com> wrote:
> On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <luberti(at)archicoop(dot)it> wrote:
>
> I think that's because Postgres does not have deferred constraint checks.

I believe it does. See
http://www.postgresql.org/docs/8.3/interactive/sql-set-constraints.html
and the DEFERRABLE keyword in CREATE TABLE.

Or am I missing something here?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message W S 2008-04-10 18:27:38 Way to shutdown/freeze/stop an individual database without taking postmaster down?
Previous Message Bruno Lavoie 2008-04-10 17:55:06 ODBCng vs psqlODBC