Horton

Re: Odd Locking Problem

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: John A Meinel <john@arbash-meinel.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Postgresql Performance <pgsql-performance@postgresql.org>
Date: 2005-08-15T15:19:44Z
Lists: pgsql-performance 
On Thu, 11 Aug 2005 16:11:58 -0500, John A Meinel
<john@arbash-meinel.com> wrote:
>the insert is occurring into table 'a' not table 'b'.
>'a' refers to other tables, but these should not be modified.

So your "a" is Alvaro's "b", and one of your referenced tables is
Alvaro's "a".  This is further supported by the fact that the problem
doesn't occur with 8.1.

Servus
 Manfred