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
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 |