Re: BUG #5689: UPDATE locks index before table resulting in deadlock

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5689: UPDATE locks index before table resulting in deadlock
Дата
Msg-id 5499.1286029400@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5689: UPDATE locks index before table resulting in deadlock  ("Peter Ajamian" <peter@pajamian.dhs.org>)
Список pgsql-bugs
Дерево обсуждения 
"Peter Ajamian" <peter@pajamian.dhs.org> writes:
> From what I can understand, the UPDATE is trying to lock the index before
> locking the table.

That is not the case, as study of the source code will prove to you.

I think what probably happened here is that the UPDATE was part of
a transaction that already had some relevant locks, but you haven't
provided enough information to diagnose it beyond that.

            regards, tom lane

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

Предыдущее
От: "Peter Ajamian"
Дата:
Сообщение: BUG #5689: UPDATE locks index before table resulting in deadlock
Следующее
От: Tom Lane
Дата:
Сообщение: Re: src/tools/fsync/test_fsync.c does not compile