Re: deadlock detected during insert

Поиск
Список
Период
Сортировка
От A.Bhuvaneswaran
Тема Re: deadlock detected during insert
Дата
Msg-id Pine.LNX.4.44.0303071236160.1047-100000@Bhuvan.bksys.co.in
обсуждение исходный текст
Ответ на Re: deadlock detected during insert  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: deadlock detected during insert  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-admin
> If you're using foreign keys on the table that you're inserting into it's
> possible that it's waiting  on another transaction doing an insert to the
> same key or on a change to the referenced table.

Can you able to give some test cases? Here i have tried, but unable to
detect deadlock.

BTW, do we have any link about deadlock detection during insert command as
we have for update command?

regards,
bhuvaneswaran


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

Предыдущее
От: "Mr.F"
Дата:
Сообщение: Re: New Interface for Win
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: deadlock detected during insert