Deadlock error when inserting single row - Mailing list pgsql-general

From d a
Subject Deadlock error when inserting single row
Date
Msg-id 20020626232625.99217.qmail@web11202.mail.yahoo.com
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: unlimited undo/journaling
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Strange behaviour of SELECT ... IN