Connecting Tech Pros Worldwide Forums | Help | Site Map

LOCK.tag(figuring out granularity of lock)--

Jenny -
Guest
 
Posts: n/a
#1: Nov 11 '05
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme:

"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. "


is blockId same as tag.objId.blkno? what field in LOCK.tag is tupleId?
thanks
jenny

__________________________________________________ _______________
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Closed Thread