[BUGS] offsetNumber offnum(LOCKTAG in lock.c)

2003-09-04 Thread Sumaira Maqsood Ali
the offnum of LOCKTAG I gather indicates which row (tuple) is being locked in a row level locking. But when I lock 2 diffrent rows of a table, offset for both is 0. and also offset is 0 if i take a table lock on the same table. (blkno is the same for all three locks)..shouldnt the OffsetNumber

[BUGS] LOCK.tag( granuarity oflocks)

2003-08-25 Thread Sumaira Maqsood Ali
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. Fi