X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 07D48D1B548; Fri, 3 Oct 2003 14:53:01 +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 63030-08; Fri, 3 Oct 2003 11:52:19 -0300 (ADT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id E9192D1B54B; Fri, 3 Oct 2003 11:52:12 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id h93F4mBb009762; Fri, 3 Oct 2003 18:04:48 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id h93F4l3x009758; Fri, 3 Oct 2003 18:04:47 +0300 Date: Fri, 3 Oct 2003 18:04:47 +0300 (EEST) From: achill@matrix.gatewaynet.com To: Tom Lane Cc: pgsql-hackers@postgresql.org, Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec In-Reply-To: <19369.1065192216@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/45 X-Sequence-Number: 15445 On Fri, 3 Oct 2003, Tom Lane wrote: > > I think in 7.4 there may be an optimization that skips the tuple > projection step in this particular case, but if you can in fact see > t_tableOid in 7.4, it'd be an implementation artifact rather than > something we will promise to support in future. The correct way if you > want to see tableoid is to select it: > > select tableoid,* from foobar where ... > > and then extract it from the result using the usual field-access > routines. Thanx. P.S. are there gonna be changes in SPI or internal structs in 7.4? > > regards, tom lane > -- -Achilleus