Postgres Pro
Downloads
Home   >   mailing lists

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

From Dennis Brakhane
Subject Re: begin transaction locks out other connections
Date
Msg-id 226a19190804101059s2363c95dx4fad42ca15c2f186@mail.gmail.com
Whole thread Raw
In response to Re: begin transaction locks out other connections  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Responses Re: begin transaction locks out other connections  (Craig Ringer <craig@postnewspapers.com.au>)
Re: begin transaction locks out other connections  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-general
Tree view 
On Thu, Apr 10, 2008 at 4:40 PM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
> On Thu, Apr 10, 2008 at 7:18 PM, Ivano Luberti <luberti@archicoop.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?

pgsql-general by date:

Previous
From: "Jan de Visser"
Date:
Subject: Re: how to use transaction isolation
Next
From: Andrew Falanga
Date:
Subject: Re: How does psql actually implement the \d commands