Re: deadlock detected during insert - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: deadlock detected during insert
Date
Msg-id 20030306075909.I79234-100000@megazone23.bigpanda.com
Whole thread Raw
In response to deadlock detected during insert  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
Responses Re: deadlock detected during insert  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-admin
On Thu, 6 Mar 2003, A.Bhuvaneswaran wrote:

> 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?

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.


pgsql-admin by date:

Previous
From: Aspire Something
Date:
Subject: Re: New Interface for Win
Next
From: Justin Clift
Date:
Subject: Re: [pgsql-advocacy] uppercase = lowercase