| From: | "Jenny -" <nat_lazy(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | LOCK.tag(figuring out granularity of lock)-- |
| Date: | 2003-08-25 14:45:40 |
| Message-ID: | BAY1-F88N3sYyCw0UXD0003d9d7@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
_________________________________________________________________
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Köhler | 2003-08-25 14:49:40 | PostgreSQL and HA? |
| Previous Message | Tom Lane | 2003-08-25 14:31:17 | Re: How do I find what views depend on a particular table? |