Re: problem with NOTICE: _outNode: don't know how to print type
Ari Jolma <ajolma@water.hut.fi>
From: Ari Jolma <ajolma@water.hut.fi>
To: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
Cc: Ari Jolma <ajolma@water.hut.fi>, pgsql-general@postgresql.org
Date: 2000-05-25T18:24:28Z
Lists: pgsql-general
On Fri, 26 May 2000, Martijn van Oosterhout wrote: > Ari Jolma wrote: > > template1=> select a from a union select a from a where a in (select a from > > a); > > NOTICE: _outNode: don't know how to print type 1044119613 > > NOTICE: _outNode: don't know how to print type 1044119613 > > a > > - > > (0 rows) > > Hmm, I may be missing something, but "select a from a" is not > a legal statement. As the message suggests, a is not a > printable type. Maybe you meant a.* ? The SQL statement above is just for showing what kind of statement causes the problem. I originally noticed the problem when I gave \l and then did a little research and found out that actually \l is implemented as something resembling what I wrote above. I was just trying to write the simplest SQL statement I could to generate the problem. It seems that there needs to be a union and a subselect. And the really curious thing is that this problem seems to depend on which redhat version there is! Ari Jolma