granularity of locks in postgresql

From: "Jenny -" <nat_lazy(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: granularity of locks in postgresql
Date: 2003-07-26 17:59:49
Message-ID: BAY1-F71NgDPex1EglF000075c6@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The following lines are from readme file present in the
\src\backend\storage\lmgr folder of postgresql

"If we are setting a table level lock
Both the blockId and tupleId (in an item pointer this is called
the position) are set to invalid, if it is a page level lock the
blockId is valid, while the tupleId is still invalid. Finally if
this is a tuple level lock (we currently never do this) then both
the blockId and tupleId are set to valid specifications."

I dont see any field called tupleId in LockTag..does it have another name?
Also, "(we currently never do this)"--> does this mean that we currently can
acquire tuplelevel(row level) locks in postgresql?
Thank you
Jenny

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jenny - 2003-07-26 18:47:51 Identifying object locked
Previous Message Bruce Momjian 2003-07-26 17:22:16 Re: parallel regression test failure