Re: identifying each individual tuple locked - Mailing list pgsql-general

From Jenny -
Subject Re: identifying each individual tuple locked
Date
Msg-id BAY1-F68rAXBirbThA900012f50@hotmail.com
Whole thread Raw
In response to identifying each individual tuple locked  ("Jenny -" <nat_lazy@hotmail.com>)
List 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?


>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


pgsql-general by date:

Previous
From: Chris Bowlby
Date:
Subject: Re: Table name lengths...
Next
From: Bruno Wolff III
Date:
Subject: Re: Commercial postgresql