Re: [HACKERS] Error with views containing sub-queries with distinct

[Tom Lane]

Sean P. Thomas [EMAIL PROTECTED] writes:
 Last night I just upgraded to a nightly snapshot of 7.4 and noticed an 
 error on queries that had previously worked (in version 7.3.x and 
 previous 7.4's snapshots up to about a month old).

Fixed, thanks for the test case.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Error with views containing sub-queries with distinct

[Tom Lane]

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