Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: identifying each individual tuple locked
Date
Msg-id 23646.1062526124@sss.pgh.pa.us
Whole thread Raw
In response to identifying each individual tuple locked  ("Jenny -" <nat_lazy@hotmail.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Jenny -"
Date:
Subject: identifying each individual tuple locked
Next
From: Jeffrey Melloy
Date:
Subject: Re: segfaults / backend crashing