Re: Locking with foreign key constraints - Mailing list pgsql-general

From Grant McLean
Subject Re: Locking with foreign key constraints
Date
Msg-id 1090462504.1034.3.camel@putnam
Whole thread Raw
In response to Locking with foreign key constraints  (<wespvp@syntegra.com>)
List pgsql-general
On Thu, 2004-07-22 at 02:54, wespvp@syntegra.com wrote:
> Will 7.5 fix the issue of the over-zealous locking with foreign key
> constraints - where two separate transactions can't simultaneously insert
> records that reference the same parent record?

The TODO list [1] contains this entry which probably covers what you
(and I) want:

  Implement dirty reads or shared row locks and use them in RI triggers

This item has *not* been marked for inclusion in 7.5.  Shame.

1. http://developer.postgresql.org/todo.php

Regards
Grant


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pgadmin 3
Next
From: "Andrew Bartley"
Date:
Subject: Hex to char