Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: SZŰCS Gábor <surrano(at)mailbox(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108)
Date: 2002-12-12 14:19:47
Message-ID: 6005.1039702787@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano(at)mailbox(dot)hu> writes:
> -- #2. This throws an error:
> tir=> (SELECT
> tir(> (SELECT az_jel from x where az=t.x) as x_az_jel
> tir(> FROM t_item t
> tir(> WHERE -- snip...
> tir-> ORDER BY t.az_jel, t.teljesites;
> ERROR: ExecEvalExpr: unknown expression type 108

You have not mentioned what PG version you are using, but if it's 7.3,
this is a known bug already fixed for 7.3.1. The patch was posted here
a week ago.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2002-12-12 14:33:11 Re: INDEX suggestion needed
Previous Message James F 2002-12-12 14:13:14 Re: Is it possible to Import tables and its data from Ms Access