Re: ERROR: cache lookup failed for type 0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: cache lookup failed for type 0
Дата
Msg-id 421.1105136624@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: cache lookup failed for type 0  (Tzahi Fadida <tzahi_ml@myrealbox.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: bgwriter
Следующее
От: Tzahi Fadida
Дата:
Сообщение: returning a setof tuples like a subquery was(RE: ERROR: cache lookup failed for type 0 )