In response to Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>: > In response to Bill Moseley <moseley@xxxxxxxx>: > > > On Sun, May 03, 2009 at 09:08:29PM -0400, Tom Lane wrote: > > > > There are no other updates to that account table in the transaction, so I'm > > > > confused how that is causing a deadlock. > > > > > > Is there more than one row with the target id? > > > > No. It's a single SERIAL primary key. > > I've never gone to the trouble to isolate this to a reproducible test ... > In any event, I hope that information is helpful to you. And on second read ... that has absolutely nothing to do with your scenario ... -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
