Re: ERROR: cache lookup failed for type 0 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cache lookup failed for type 0
Date
Msg-id 421.1105136624@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: cache lookup failed for type 0  (Tzahi Fadida <tzahi_ml@myrealbox.com>)
Responses returning a setof tuples like a subquery was(RE: ERROR: cache lookup failed for type 0 )  (Tzahi Fadida <tzahi_ml@myrealbox.com>)
Re: ERROR: cache lookup failed for type 0  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tzahi Fadida <tzahi_ml@myrealbox.com> writes:
> well, I tried the heap_deformtuple and I am getting now:
> select testgetrows();
> server closed the connection unexpectedly

You didn't palloc the values array.  Any reasonable compiler would have
warned you about that BTW.  If you don't have compiler warnings enabled,
learn to use them.

Also, I'd recommend using the tupledesc from the just-opened lRel;
fetching it via an independent path is just asking for trouble.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: bgwriter
Next
From: Tzahi Fadida
Date:
Subject: returning a setof tuples like a subquery was(RE: ERROR: cache lookup failed for type 0 )