Re: apparent deadlock

Поиск
Список
Период
Сортировка
От Michael P. Soulier
Тема Re: apparent deadlock
Дата
Msg-id 20081118220715.GA27428@e-smith.com
обсуждение исходный текст
Ответ на Re: apparent deadlock  ("Michael P. Soulier" <michael_soulier@mitel.com>)
Ответы Re: apparent deadlock  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: New shapshot RPMs (Nov 18, 2008) are ready for testing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: apparent deadlock