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

Tzahi Fadida <tzahi_ml@myrealbox.com> writes:
> Hi, I am learning how to use the c functions and my function below works
> when I do:
> select testgetrows();
> but when I do select * from testgetrows(); I am getting:
> "ERROR:  cache lookup failed for type 0"
> Whats's the problem?

I don't think it's safe to do HeapTupleGetDatum() directly on a tuple
obtained from heap_getnext.  You need to copy it.

            regards, tom lane