variable not found in subplan target list?

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: variable not found in subplan target list?
Date: 2003-11-24 06:35:49
Message-ID: 3FC1A6C5144.3F0DKG@129.180.47.120
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I've got the message "ERROR: variable not found in subplan target lists"
when I have a union between 2 views. Both selects from the views run
without the union. Same result using intersect and except. Same result
using any of them with the all qualifier. Explain of the union gives
the error, explain of each individual select gives a result.

The view definitions contain unions and cross joins.

The error still occurs if I simplify the selects down to

select 'abc' from view1
union
select 'cba' from view2

"PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.96"
redhat 7.2 (2.4.7-10)

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-11-24 06:48:17 Re: variable not found in subplan target list?
Previous Message Tom Lane 2003-11-23 18:43:49 Re: Bug Report