> 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
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 20
"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 b
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 MS
