Re: deadlock detected during insert

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: deadlock detected during insert
Date: 2003-03-06 16:01:29
Message-ID: 20030306075909.I79234-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jason Pyeron 2003-03-06 16:39:20 Deal with this. Re: Majordomo results: unsubscribe
Previous Message Aspire Something 2003-03-06 14:48:13 Re: New Interface for Win