Re: transaction blocking inserts in postgresql 7.3

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Chris Hutchinson" <chris(at)hutchinsonsoftware(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: transaction blocking inserts in postgresql 7.3
Date: 2003-03-26 11:28:53
Message-ID: 200303261128.53428.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 26 Mar 2003 9:59 am, Chris Hutchinson wrote:
> I'm curious why postgres should be blocking like this, as the foreign key
> constraint is presumably read-based.

Actually, I believe it's a write lock (which is the cause of the problem).
What it actually needs to be is a "prevent writes" lock but there is no such
thing at the moment.

--
Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2003-03-26 11:30:46 Re: transaction blocking inserts in postgresql 7.3
Previous Message James Gregory 2003-03-26 11:01:37 Re: Advice on Database Schema