Re: identifying each individual tuple 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: identifying each individual tuple locked
Date: 2003-09-02 18:08:44
Message-ID: 23646.1062526124@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2003-09-02 18:08:45 Re: segfaults / backend crashing
Previous Message Jenny - 2003-09-02 17:59:46 identifying each individual tuple locked

Browse pgsql-hackers by date

  From Date Subject
Next Message Jenny - 2003-09-02 18:56:42 Re: identifying each individual tuple locked
Previous Message Jenny - 2003-09-02 17:59:46 identifying each individual tuple locked