On Sun, Sep 07, 2003 at 04:07:42PM -0700, Jenny - wrote:
> >A row lock is represented by storing the locking transaction's ID in
> >xmax and setting the HEAP_MARKED_FOR_UPDATE infomask bit. The bit is
> >needed to distinguish this from the case where the transaction is
> >deleting the tuple.
>
>
anks
From: Tom Lane <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [HACKERS] table-level and row-level locks. Date: Wed, 20 Aug
2003 14:45:23 -0400
Koichi Suzuki <[EMAIL PROTECTED]> writes:
> I need to know where such "lock marks" are s
if table and page are locked in src/backend/storage/lmgr/lmgr.c by
LockRelation() and LockPage respectively, in which file and by which
function is a row locked?
thanks
Jenny
From: "Jenny -" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: [HACKERS] table-level and row-l
Subject: Re: [HACKERS] table-level and row-level locks. Date: Wed, 20 Aug
2003 14:45:23 -0400
Koichi Suzuki <[EMAIL PROTECTED]> writes:
> I need to know where such "lock marks" are stored in the source level.
A row lock is represented by storing the locking transaction's ID i
Koichi Suzuki <[EMAIL PROTECTED]> writes:
> I need to know where such "lock marks" are stored in the source level.
A row lock is represented by storing the locking transaction's ID in
xmax and setting the HEAP_MARKED_FOR_UPDATE infomask bit. The bit is
needed to distinguish this from the case whe
Hi,
(B
(BI understand this is very old topics but ...
(BI tried to find where such lock mark is defined in each tuple on disk, but I
(Bfailed to find such definition in include/access/htup.h. Only the bit
(Brelevant to lock is HEAP_XMAX_UNLOGGED and I understand this bit is used only
(Bwhen
Once more unto the breach -
Could you please abstain from sending HTML email to the list ?
Many thanks !
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
"Jenny -" <[EMAIL PROTECTED]> writes:
> Iam trying to acquire rowlevel locks in
> postgresql. I try doing this:
> 'select * from students where name='Larry' for update;
> But by looking at the holding array of proclock , I've noticed that by doing
> this only
> AccessShareLock gets acquired wh
