Re: Tracking down a deadlock

In response to Bill Moran <wmoran@potentialtech.com>:

> In response to Bill Moseley <moseley@hank.org>:
>
> > 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/