"Sean P. Thomas" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster