identifying rows locked in row level locking - Mailing list pgsql-general

From Jenny -
Subject identifying rows locked in row level locking
Date
Msg-id BAY1-F104lWJLWrQKGs000244e0@hotmail.com
Whole thread Raw
List 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 by date:

Previous
From: "Chris Boget"
Date:
Subject: Re: Trunc in Postgres
Next
From: "Jenny -"
Date:
Subject: identifying rows locked in row level locking