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

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