470,581 Members | 2,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

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

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

__________________________________________________ _______________
Get MSN 8 and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
0 1339

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Rich Sienkiewicz | last post: by
3 posts views Thread by xixi | last post: by
9 posts views Thread by Jane | last post: by
reply views Thread by Bruce Pullen | last post: by
7 posts views Thread by Sunny | last post: by
3 posts views Thread by Raj | last post: by
5 posts views Thread by Jacob | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.