Re: deadlock detected during insert

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: deadlock detected during insert
Date: 2003-03-07 07:09:36
Message-ID: Pine.LNX.4.44.0303071236160.1047-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mukund Pate 2003-03-07 07:22:40 database recovery problem
Previous Message Mr.F 2003-03-07 06:47:32 Re: New Interface for Win