Re: identifying each individual tuple locked

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: identifying each individual tuple locked
Дата
Msg-id 23646.1062526124@sss.pgh.pa.us
обсуждение исходный текст
Ответ на identifying each individual tuple locked  ("Jenny -" <nat_lazy@hotmail.com>)
Список pgsql-general
"Jenny -" <nat_lazy@hotmail.com> writes:
> 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 ...

            regards, tom lane

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

Предыдущее
От: "Jenny -"
Дата:
Сообщение: identifying each individual tuple locked
Следующее
От: Jeffrey Melloy
Дата:
Сообщение: Re: segfaults / backend crashing