identifying rows locked in row level locking

Поиск
Список
Период
Сортировка
От Jenny -
Тема identifying rows locked in row level locking
Дата
Msg-id BAY1-F104lWJLWrQKGs000244e0@hotmail.com
обсуждение исходный текст
Список pgsql-general
 > I understand that ObjID of LOCKtag recognizes each individual row locked
by
>a row level lock. BUt i have noticed that if i lock 2 different rows of the
>same table they have the same blkno. is this deduction ok?

If they happen to be stored in the same block, they'd have the same blkno
...


then how would we recognize each individual row locked?

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus


В списке pgsql-general по дате отправления:

Предыдущее
От: "Chris Boget"
Дата:
Сообщение: Re: Trunc in Postgres
Следующее
От: "Jenny -"
Дата:
Сообщение: identifying rows locked in row level locking