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

From A.Bhuvaneswaran
Subject Re: deadlock detected during insert
Date
Msg-id Pine.LNX.4.44.0303071236160.1047-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Re: deadlock detected during insert  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: deadlock detected during insert
List pgsql-admin
> 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.

Can you able to give some test cases? Here i have tried, but unable to
detect deadlock.

BTW, do we have any link about deadlock detection during insert command as
we have for update command?

regards,
bhuvaneswaran


pgsql-admin by date:

Previous
From: "Mr.F"
Date:
Subject: Re: New Interface for Win
Next
From: Stephan Szabo
Date:
Subject: Re: deadlock detected during insert