"Sean P. Thomas" <spt(at)ulanji(dot)com> writes:
> I get:
> JOIN qualification may not refer to other relations
Problem confirmed here, will look into it. I have a feeling this is a
bad side-effect of this patch:
2003-10-13 19:48 tgl
* src/backend/optimizer/prep/prepjointree.c: pull_up_subqueries()
should copy the subquery before starting to modify it. Not sure
why I'd thought it would be a good idea to do differently way back
when, but Greg Stark exposed the folly of doing so ...
but I don't see why as yet.
regards, tom lane