On Mon, 24 Nov 2003, Klint Gore wrote: > 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)
Can you send a test case with table and view definitions, it's hard to generate one from just the information above. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
