Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Mon, 24 Nov 2003 17:35:49 +1100
  • Message-id: <3FC1A6C5144.3F0DKG@129.180.47.120> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group