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

2003-10-18 Thread 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.

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

2003-10-17 Thread 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_sub

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

2003-10-17 Thread Sean P. Thomas
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). I have a view that I can distill into a base case of: CREATE VIEW testing_v AS SELECT table_a.* FRO