Skip site navigation (1) Skip section navigation (2)

LOCK.tag(figuring out granularity of lock)

From: Sumaira Maqsood Ali <sali(at)purdue(dot)edu>
To: pgsql-docs(at)postgresql(dot)org
Subject: LOCK.tag(figuring out granularity of lock)
Date: 2003-08-24 22:28:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
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?

pgsql-docs by date

Next:From: Tom LaneDate: 2003-08-25 14:43:07
Subject: Re: read commited
Previous:From: pgmanDate: 2003-08-22 10:11:07
Subject: Re: Your application

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group