Re: do foreign key checks lock parent table ?

Поиск
Список
Период
Сортировка
От
Тема Re: do foreign key checks lock parent table ?
Дата
Msg-id Pine.LNX.4.33.0204030016450.24260-100000@12-220-136-82.client.insightBB.com
обсуждение исходный текст
Ответ на Re: do foreign key checks lock parent table ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: do foreign key checks lock parent table ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: do foreign key checks lock parent table ?  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-general
So turning intially deferred on is a suitable solution?  It seems
to work OK in this simple test case.

On Tue, 2 Apr 2002, Stephan Szabo wrote:
> The locks being grabbed are a bit stronger than they need to be
> (if you want more info, there was a bit of discussion on -hackers
> recently).  The updates should block updates on parent of the
> referenced row but don't need to block other child updates but there's
> no current lock level that is quite right.


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Sojan
Дата:
Сообщение: Re: Problem with referential integrity within functions (bug?)
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: [HACKERS] v7.2.1 Released: Critical Bug Fix