Re: Deadlock. Referential Integrity checks select for update?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Deadlock. Referential Integrity checks select for update?
Дата
Msg-id 2301.1088140705@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Deadlock. Referential Integrity checks select for update?  (Grant McLean <grant@catalyst.net.nz>)
Список pgsql-general
Дерево обсуждения 
Grant McLean <grant@catalyst.net.nz> writes:
> I don't understand why these two queries include "FOR UPDATE".

The point is to lock the referenced rows so they cannot be deleted
before the referencing transaction commits.  FOR UPDATE is an overly
strong lock, but we do not presently have any weaker lock that will
serve.  You can find lots more about this issue in the archives...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Running two postmasters on one host: could not create semaphores
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: tsearch2,pgsql 7.4.[1|2], pg_dump problem