X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4521ED1B91B for ; Thu, 4 Sep 2003 01:24:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 66594-08 for ; Wed, 3 Sep 2003 22:24:48 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id A931BD1B8F5 for ; Wed, 3 Sep 2003 22:24:44 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h841OgDh068889 for ; Thu, 4 Sep 2003 01:24:42 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h841KgEY068277 for pgsql-docs@postgresql.org; Thu, 4 Sep 2003 01:20:42 GMT From: Sumaira Maqsood Ali X-Newsgroups: comp.databases.postgresql.docs Subject: OffsetNumber offnum (LOCKTAG in lock.c) Date: Wed, 03 Sep 2003 20:17:34 -0500 Organization: Purdue University Lines: 9 Message-ID: <3F5692AE.3070608@purdue.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: news@news.purdue.edu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 (CK-PURDUE) X-Accept-Language: en-us, en To: pgsql-docs@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/19 X-Sequence-Number: 1975 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 offnum be different for each individual row lociked? if not, then what field of LOCKTAG recognizes each individual row (tuple) locked? thanks!