Re: Dead locks

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Rainer Mager" <rmager@vgkk.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-03-26T14:50:23Z
Lists: pgsql-bugs, pgsql-hackers
"Rainer Mager" <rmager@vgkk.com> writes:
> We're using PG 7.0 and 7.1beta and are having dead lock problems. The docs
> say the Postgres detects dead locks and automatically rolls back 1
> transaction to recover but this is not our experience. Are the docs
> incorrect or is this more serious?

Which beta release?

There are some known undetected-deadlock cases in 7.0, which were
repaired in late January --- that would have been beta4 or possibly
beta5, I forget now.  If you still see this behavior with 7.1RC1 then
I would like details.

			regards, tom lane