[HACKERS] granularity of locking

2003-09-02 Thread Jenny -
In the LockTag if tupleId is represented by blkno and offnum then is blockId mentioned below the same as blkno? 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

[HACKERS] granularity of locking

2003-08-01 Thread Jenny -
what determines what level of locking(table level, page level or row level) an object is locked in? how do we determine from postgresql code what level a object is locked in? Iam working on a project where i have to display the locks information of all the transactions that have acquired locks i