LOCK.tag(figuring out granularity of lock)

Поиск
Список
Период
Сортировка
От Jenny -
Тема LOCK.tag(figuring out granularity of lock)
Дата
Msg-id BAY1-F129wP6SAH2JZZ0000671c@hotmail.com
обсуждение исходный текст
Ответы Re: LOCK.tag(figuring out granularity of lock)  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme:

"If we are setting a table level lockboth the blockId and tupleId (in an item pointer this is calledthe position) are
setto invalid, if it is a page level lock theblockId is valid, while the tupleId is still invalid.  Finally ifthis is a
tuplelevel lock (we currently never do this) then boththe blockId and tupleId are set to valid specifications.  "
 

how do we check whether blockId and tupleId of LOCK.tag are valid or 
invalid?
is blockId same as tag.objId.blkno?  what field in LOCK.tag is tupleId?
thanks
jenny

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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: consistency check on SPI tuple count failed
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: build on unixware 713