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

HeapTuple->t_tableOid==0 after SPI_exec

From: achill(at)matrix(dot)gatewaynet(dot)com
To: pgsql-hackers(at)postgresql(dot)org, <pgsql-sql(at)postgresql(dot)org>
Subject: HeapTuple->t_tableOid==0 after SPI_exec
Date: 2003-10-03 12:56:07
Message-ID: Pine.LNX.4.44.0310031546360.5168-100000@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
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


Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-10-03 13:39:30
Subject: Re: Weird locking situation
Previous:From: JeffDate: 2003-10-03 12:36:42
Subject: Re: count(*) slow on large tables

pgsql-sql by date

Next:From: John B. ScaliaDate: 2003-10-03 13:18:44
Subject: Bug in psql - Postgresql 7.3.1?
Previous:From: btoberDate: 2003-10-03 12:12:29
Subject: Re: How to figure out when was a table created

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