| From: | "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | deadlock detected during insert |
| Date: | 2003-03-06 04:56:59 |
| Message-ID: | Pine.LNX.4.44.0303061009380.1832-100000@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A.Bhuvaneswaran | 2003-03-06 06:06:14 | deadlock detected during insert |
| Previous Message | Bruce Momjian | 2003-03-06 04:34:37 | Re: uppercase = lowercase |