Re: apparent deadlock

From: "Michael P(dot) Soulier" <michael_soulier(at)mitel(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: apparent deadlock
Date: 2008-11-18 22:07:16
Message-ID: 20081118220715.GA27428@e-smith.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18/11/08 Michael P. Soulier did say:

> I found this:
>
> http://fishbowl.pastiche.org/2004/02/26/finding_open_locks_on_postgresql/
>
> it revealed where the locks were consumed.

Does postgres implicitely lock tables? I noticed that I had an alter
table command but I didn't lock, and yet there was a lock being
requested on the table by that process...

Thanks,
Mike
--
Michael P. Soulier <michael_soulier(at)mitel(dot)com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einstein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-18 22:15:44 Re: apparent deadlock
Previous Message Devrim GÜNDÜZ 2008-11-18 21:57:53 New shapshot RPMs (Nov 18, 2008) are ready for testing