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?
thanks
jenny

_________________________________________________________________
Get MSN 8 and help protect your children with advanced parental controls.  
http://join.msn.com/?page=features/parental


Tue, 02 Sep 2003 10:59:46 -0700
"Jenny -" <nat_lazy@hotmail.com>
identifying each individual tuple locked
"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

Tue, 02 Sep 2003 14:08:44 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: identifying each individual tuple locked 