Re: begin transaction locks out other connections

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "Ivano Luberti" <luberti(at)archicoop(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: begin transaction locks out other connections
Date: 2008-04-10 14:40:57
Message-ID: 2e78013d0804100740r2dc36952s4255437a09ea9579@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <luberti(at)archicoop(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-10 14:48:32 Re: pl/java on Solaris
Previous Message Stefan Schwarzer 2008-04-10 14:23:50 Proper Installation of Postgres and Postgis on 10.5 Intel