deadlock detected during insert

Поиск
Список
Период
Сортировка
От A.Bhuvaneswaran
Тема deadlock detected during insert
Дата
Msg-id Pine.LNX.4.44.0303061009380.1832-100000@Bhuvan.bksys.co.in
обсуждение исходный текст
Список pgsql-admin
Hi,

I am using pgsql 7.2.3 on redhat linux 7.3.

I am facing the deadlock detected error in transaction during insert
command. How can i fix this?

After googling, i found that when two simultaneous transactions try to
wait for completion of one another(update commands), the deadlock would be
detected and one transaction would be rolled back. Locking the table in
the same order must help.

But in my case it is insert command? I googled, but didnot get any related
links. Do i have to lock the table? Which lock mode should i use then?

TIA.

regards,
bhuvaneswaran


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

Предыдущее
От: "Ben Jordan"
Дата:
Сообщение: Re: Performance problems with Postgresql
Следующее
От: Robert Treat
Дата:
Сообщение: Re: [pgsql-advocacy] uppercase = lowercase