Re: Locking with foreign key constraints

From: Grant McLean <grant(at)catalyst(dot)net(dot)nz>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Locking with foreign key constraints
Date: 2004-07-22 02:15:04
Message-ID: 1090462504.1034.3.camel@putnam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2004-07-22 at 02:54, wespvp(at)syntegra(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Bartley 2004-07-22 03:23:25 Hex to char
Previous Message Martijn van Oosterhout 2004-07-22 00:24:06 Re: pgadmin 3