Postgres Pro
Downloads
Home   >   mailing lists

HeapTuple->t_tableOid==0 after SPI_exec - Mailing list pgsql-sql

From achill@matrix.gatewaynet.com
Subject HeapTuple->t_tableOid==0 after SPI_exec
Date
Msg-id Pine.LNX.4.44.0310031546360.5168-100000@matrix.gatewaynet.com
Whole thread Raw
Responses Re: HeapTuple->t_tableOid==0 after SPI_exec  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How to figure out when was a table created
Next
From: Tom Lane
Date:
Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec