Re: [GENERAL] trying to make sense of deadlocks

2009-02-09 Thread Richard Yen
在 Feb 9, 2009 8:52 PM 時, Tom Lane 寫到: Richard Yen writes: It seems like all the deadlocks are for tuple (3,60), but strangely, tuple (3,60) on the account table doesn't exist. Perhaps it was deleted? According to the account table, the account with id = 39271 (which the UPDATE statements ca

Re: [GENERAL] trying to make sense of deadlocks

2009-02-09 Thread Tom Lane
Richard Yen writes: > It seems like all the deadlocks are for tuple (3,60), but strangely, > tuple (3,60) on the account table doesn't exist. Perhaps it was > deleted? According to the account table, the account with id = 39271 > (which the UPDATE statements call for) corresponds to tuple

Re: [GENERAL] trying to make sense of deadlocks

2009-02-09 Thread Adam Rich
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Richard Yen > Sent: Monday, February 09, 2009 4:18 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] trying to make sense of deadlocks > > Hi, > > I'm tryin