> 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?
From: Tom Lane <[EMAIL PROTECTED]>
To: "Jenny -" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [GENERAL] identifying each individual tuple locked Date: Tue, 02 Sep 2003 14:08:44 -0400
"Jenny -" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
_________________________________________________________________ MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
