Thread: Locking with foreign key constraints

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?

Wes

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