From: | "Jenny -" <nat_lazy(at)hotmail(dot)com> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us, suzukikui(at)nttdata(dot)co(dot)jp |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: table-level and row-level locks. |
Date: | 2003-09-07 23:07:42 |
Message-ID: | BAY1-F117lHzgVCyiuC00021418@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>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.
where is 'HEAP_MARKED_FOR_UPDATE infomask bit' found ?
thanks
>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: suzukikui(at)nttdata(dot)co(dot)jp
>CC: pgsql-hackers(at)postgresql(dot)org
>Subject: Re: [HACKERS] table-level and row-level locks. Date: Wed, 20 Aug
>2003 14:45:23 -0400
>
>Koichi Suzuki <suzukikui(at)nttdata(dot)co(dot)jp> 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 where the transaction is
>deleting the tuple.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
_________________________________________________________________
Use custom emotions -- try MSN Messenger 6.0!
http://www.msnmessenger-download.com/tracking/reach_emoticon
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2003-09-07 23:25:30 | Re: Needed function IF(expr, expr, expr) |
Previous Message | Greg Stark | 2003-09-07 23:00:03 | Re: [GENERAL] Needed function IF(expr, expr, expr) |