Re: identifying each individual tuple locked

> > 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(at)sss(dot)pgh(dot)pa(dot)us>
>To: "Jenny -" <nat_lazy(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
>Subject: Re: [GENERAL] identifying each individual tuple locked Date: Tue,
>02 Sep 2003 14:08:44 -0400
>
>"Jenny -" <nat_lazy(at)hotmail(dot)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(at)postgresql(dot)org)

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