Re: deadlock - Mailing list pgsql-general

From Scott Marlowe
Subject Re: deadlock
Date
Msg-id dcc563d10804030951m5b26c27ifd16591da7287523@mail.gmail.com
Whole thread Raw
In response to deadlock  (rihad <rihad@mail.ru>)
List pgsql-general
On Thu, Apr 3, 2008 at 10:29 AM, rihad <rihad@mail.ru> wrote:
> Hi,
>
>  I've come across a strange deadlock that I need your help with. There are
> two copies of the same Perl daemon running on a 2 cpu box. The program is
> pretty simple (because I wrote it :)) so I can trace its pathway fairly
> well: in it, there's a single "LOCK table foo" occurring part way through a
> transaction that sometimes ends up as this:

For what reason is the table being locked?

pgsql-general by date:

Previous
From: "William Temperley"
Date:
Subject: Secure "where in(a,b,c)" clause.
Next
From: "Pavan Deolasee"
Date:
Subject: Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong