deadlock detected during insert
deadlock detected during insert
От:
"A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
Дата:
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