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 8CC10D1B506; Fri, 3 Oct 2003 12:44:23 +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 39686-02; Fri, 3 Oct 2003 09:43:37 -0300 (ADT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 68DFED1B53F; Fri, 3 Oct 2003 09:43:32 -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 h93Cu7Bb009224; Fri, 3 Oct 2003 15:56:07 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id h93Cu76S009220; Fri, 3 Oct 2003 15:56:07 +0300 Date: Fri, 3 Oct 2003 15:56:07 +0300 (EEST) From: achill@matrix.gatewaynet.com To: pgsql-hackers@postgresql.org, Subject: HeapTuple->t_tableOid==0 after SPI_exec Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME, USER_AGENT_PINE X-Spam-Level: * X-Archive-Number: 200310/42 X-Sequence-Number: 15442 Hi, i notice that when HeapTuple data are populated by a trigger then the table oid can be retrieved from HeapTuple->t_tableOid. When HeapTuple is populated by SPI_exec("select * from foobar when id=667"); tuple = SPI_tuptable->tvals[0] (id is PK and row with 667 exists) then tuple->t_tableOid is always 0. Is it a known issue?? Am i missing something? -Achilleus