

> > 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 <tgl@sss.pgh.pa.us>
>To: "Jenny -" <nat_lazy@hotmail.com>
>CC: pgsql-general@postgresql.org, pgsql-hackers@postgresql.org
>Subject: Re: [GENERAL] identifying each individual tuple locked Date: Tue, 
>02 Sep 2003 14:08:44 -0400
>
>"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
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

_________________________________________________________________
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup


Tue, 02 Sep 2003 11:56:42 -0700
"Jenny -" <nat_lazy@hotmail.com>
Re: identifying each individual tuple locked