Postgres Pro
Downloads
Home   >   mailing lists

Re: begin transaction locks out other connections - Mailing list pgsql-general

From Pavan Deolasee
Subject Re: begin transaction locks out other connections
Date
Msg-id 2e78013d0804100740r2dc36952s4255437a09ea9579@mail.gmail.com
Whole thread Raw
In response to Re: begin transaction locks out other connections  (Ivano Luberti <luberti@archicoop.it>)
Responses Re: begin transaction locks out other connections  ("Dennis Brakhane" <brakhane@googlemail.com>)
List pgsql-general
Tree view 
On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <luberti@archicoop.it> wrote:

>  Anyway I am a little surprised by this thing cause I thought that in a case
> like this the habgs should happen only at commit/rollback time.
>

I think that's because Postgres does not have deferred constraint checks.
They are checked at the execution time, instead of commit time.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Proper Installation of Postgres and Postgis on 10.5 Intel
Next
From: Tom Lane
Date:
Subject: Re: pl/java on Solaris