Re: deadlock detected during insert

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.