Re: DeadLocks..., DeadLocks...

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Bill Moran" <wmoran(at)potentialtech(dot)com>
Cc: <tom(at)tacocat(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: DeadLocks..., DeadLocks...
Date: 2007-06-14 17:11:17
Message-ID: 87bqfiv4ui.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm still not precisely clear what's going on, it might help if you posted the
actual schema and the deadlock message which lists the precise locks that
deadlocked.

Are any of the DML you mention on other tables on those tables with foreign
key references to this one?

It's impossible for two inserts on the same table to deadlock against each
other so there must be more going on than what you've described. It's hard to
help much without a complete picture.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-14 17:16:58 Re: explain analyze on a function
Previous Message Martijn van Oosterhout 2007-06-14 17:02:06 Re: changing the /tmp/ lock file?