Re: DeadLocks..., DeadLocks...

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: DeadLocks..., DeadLocks...
Дата
Msg-id 87bqfiv4ui.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: DeadLocks..., DeadLocks...  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: DeadLocks..., DeadLocks...  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: DeadLocks..., DeadLocks...  (Tom Allison <tom@tacocat.net>)
Re: DeadLocks..., DeadLocks...  (Tom Allison <tom@tacocat.net>)
Список pgsql-general
I'm still not precisely clear what's going on, it might help if you posted the
actual schema and the deadlock message which lists the precise locks that
deadlocked.

Are any of the DML you mention on other tables on those tables with foreign
key references to this one?

It's impossible for two inserts on the same table to deadlock against each
other so there must be more going on than what you've described. It's hard to
help much without a complete picture.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: changing the /tmp/ lock file?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: explain analyze on a function