Обсуждение: ERROR: tuplestore_gettuple: invalid state

Any idea what

ERROR:  tuplestore_gettuple: invalid state

could mean ?

I took the tablefunc from 7.3.3 and installed it on a 7.3.2 system.

SELECT * FROM connectby('nav', 'id_nav', 'id2_nav', 'pos', '1', 0) as
tree (id_nav int, id2_nav int, level int, serial int) join nav using
(id_nav) order by tree.serial;

TIA
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

Nabil Sayegh wrote:
> Any idea what
>
> ERROR:  tuplestore_gettuple: invalid state
>
> could mean ?
>
> I took the tablefunc from 7.3.3 and installed it on a 7.3.2 system.
>

The message itself comes from tuplestore_gettuple(), which isn't even
originated from within tablefunc.so. See
src/backend/utils/sort/tuplestore.c about half way down the file.

I don't see any changes between 7.3.2 and 7.3.3 that would cause that,
but I'd guess you should recompile contrib/tablefunc in a 7.3.2 source
tree.

Joe

Am Sam, 2003-06-28 um 01.21 schrieb Joe Conway:

> I don't see any changes between 7.3.2 and 7.3.3 that would cause that,
> but I'd guess you should recompile contrib/tablefunc in a 7.3.2 source
> tree.

That's what I did.
But it's not that important.

thx
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de