Re: Odd Locking Problem

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: John A Meinel <john(at)arbash-meinel(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Odd Locking Problem
Date: 2005-08-15 15:19:44
Message-ID: oqa1g1p1e9nmual6khn64gkqs0394vh6lf@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 11 Aug 2005 16:11:58 -0500, John A Meinel
<john(at)arbash-meinel(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-15 16:18:59 Re: Performance pb vs SQLServer.
Previous Message Stéphane COEZ 2005-08-15 09:08:06 Re: Performance pb vs SQLServer.