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

Re: HeapTuple->t_tableOid==0 after SPI_exec

From: achill(at)matrix(dot)gatewaynet(dot)com
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec
Date: 2003-10-03 15:04:47
Message-ID: Pine.LNX.4.44.0310031802570.9228-100000@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-sql
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


In response to

Responses

pgsql-hackers by date

Next:From: Andrew SullivanDate: 2003-10-03 15:17:15
Subject: Re: Thoughts on maintaining 7.3
Previous:From: Tom LaneDate: 2003-10-03 15:03:19
Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec

pgsql-sql by date

Next:From: Tom LaneDate: 2003-10-03 15:26:23
Subject: Re: Creating Index
Previous:From: Tom LaneDate: 2003-10-03 15:03:19
Subject: Re: HeapTuple->t_tableOid==0 after SPI_exec

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