Re: problem with NOTICE: _outNode: don't know how to print type

From: Ari Jolma <ajolma(at)water(dot)hut(dot)fi>
To: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
Cc: Ari Jolma <ajolma(at)water(dot)hut(dot)fi>, pgsql-general(at)postgresql(dot)org
Subject: Re: problem with NOTICE: _outNode: don't know how to print type
Date: 2000-05-25 18:24:28
Message-ID: Pine.LNX.4.10.10005252117410.19407-100000@water.hut.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message planx plnetx 2000-05-25 18:56:26 What distribution?
Previous Message Bruce Momjian 2000-05-25 17:08:17 Re: PG 7.0 is 2.5 times slower running a big report