Re: Locking with foreign key constraints

Поиск
Список
Период
Сортировка
От Grant McLean
Тема Re: Locking with foreign key constraints
Дата
Msg-id 1090462504.1034.3.camel@putnam
обсуждение исходный текст
Ответ на Locking with foreign key constraints  (<wespvp@syntegra.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: pgadmin 3
Следующее
От: "Andrew Bartley"
Дата:
Сообщение: Hex to char