Re: apparent deadlock - Mailing list pgsql-general

From Michael P. Soulier
Subject Re: apparent deadlock
Date
Msg-id 20081118220715.GA27428@e-smith.com
Whole thread Raw
In response to Re: apparent deadlock  ("Michael P. Soulier" <michael_soulier@mitel.com>)
Responses Re: apparent deadlock
List 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@mitel.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

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: New shapshot RPMs (Nov 18, 2008) are ready for testing
Next
From: Tom Lane
Date:
Subject: Re: apparent deadlock