Re: Deadlock situation using foreign keys (reproduceable)

Поиск
Список
Период
Сортировка
От Thomas O'Dowd
Тема Re: Deadlock situation using foreign keys (reproduceable)
Дата
Msg-id 1030328832.4371.72.camel@beast.uwillsee.com
обсуждение исходный текст
Ответ на Deadlock situation using foreign keys (reproduceable)  (Mario Weilguni <mario.weilguni@icomedias.com>)
Ответы Re: Deadlock situation using foreign keys (reproduceable)
Список pgsql-hackers
Hi all,

I've been having a lot of trouble with deadlocks in 7.2.1 because of
foreign keys. I dug out a couple of messages from the list archives
which cover this topic.

One particular message indicates a fix was being worked on.
--------
Date: Thu, 11 Apr 2002 09:03:06 -0700 (PDT)
From: Stephan Szabo

Please see past disussions on the fact that the lock grabbed is too
strong.  I'm going to (when I get time to work on it) try out a lower
strength lock that Alex Hayward made a patch for that should
limit/prevent these cases.  Thanks for sending a nice simple test case
to try against :)
----------

My question is if this is now resolved for 7.3? I'm trying to figure out
what I can do with my 7.2.1 problems... Has anyone got a back-ported
patch, perhaps against 7.2.2?

Any help appreciated, thanks!

Tom.
-- 
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs



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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: [GENERAL] PostgreSQL 7.2.2: Security Release
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Deadlock situation using foreign keys (reproduceable)