Deadlock error when inserting single row

From: d a <devajx(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Deadlock error when inserting single row
Date: 2002-06-26 23:26:22
Message-ID: 20020626232625.99217.qmail@web11202.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am getting deadlock errors when inserting a single
row into a table. (This being the only statement in
the transaction.) The table has a couple of foreign
key references to other tables. And there are other
more complicated transactions happening in parallel.

Are there any scenarios possible where you might get a
deadlock error when inserting data into a table (with
a single insert statement as the only statement in the
transaction)?

-Anshul

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-06-26 23:28:47 Re: Strange behaviour of SELECT ... IN
Previous Message Martijn van Oosterhout 2002-06-26 23:23:41 Re: unlimited undo/journaling