Re: BUG #4648: needless deadlock on tables having foreign-key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4648: needless deadlock on tables having foreign-key
Дата
Msg-id 19543.1234483834@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #4648: needless deadlock on tables having foreign-key  (Konstantin <kostya2702@rambler.ru>)
Ответы Re: BUG #4648: needless deadlock on tables having foreign-key
Список pgsql-bugs
Дерево обсуждения 
Konstantin <kostya2702@rambler.ru> writes:
> I just want to emphasize that mentioned implementation artifact born not
> obvious issues at applications side.

[ shrug... ]  The "implementation artifact" is that you didn't get a
deadlock *earlier*.  You can't expect to update referenced rows and
referencing rows in the same transaction and not risk deadlock against
other transactions doing the same thing.

            regards, tom lane

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

Предыдущее
От: Konstantin
Дата:
Сообщение: Re: BUG #4648: needless deadlock on tables having foreign-key
Следующее
От: Scott Carey
Дата:
Сообщение: 8.3.5: Query Planner takes 15+ seconds to plan Update or Delete queries on partitioned tables.