identifying rows locked in row level locking

From: "Jenny -" <nat_lazy(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsq-hackers(at)postgresql(dot)org
Subject: identifying rows locked in row level locking
Date: 2003-09-03 14:24:31
Message-ID: BAY1-F62JtgpLm6oT950001f2ba@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

_________________________________________________________________
Help protect your PC: Get a free online virus scan at McAfee.com.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-03 14:25:56 Re: Querying $libdir
Previous Message Jenny - 2003-09-03 14:23:24 identifying rows locked in row level locking