Re: [BUGS] Subquery with toplevel reference used to work in pg 8.4

2012-03-24 Thread Tom Lane
Mark Murawski writes: > I agree the query is a little odd, but I like backwards compatibility! AFAICT, 8.4 is broken too --- did you try any cases where the WHERE-condition should filter rows? I created this similar test case using the regression database: select * from int8_tbl t1 left join

Re: [BUGS] Subquery with toplevel reference used to work in pg 8.4

2012-03-23 Thread Jaime Casanova
On Fri, Mar 23, 2012 at 11:04 PM, Mark Murawski wrote: > > ERROR:  Upper-level PlaceHolderVar found where not expected > This is part of commit c1d9579dd8bf3c921ca6bc2b62c40da6d25372e5 which as stated in the commit log: """ tightened the error checking in this area a bit: if it was ever valid to

[BUGS] Subquery with toplevel reference used to work in pg 8.4

2012-03-23 Thread Mark Murawski
I agree the query is a little odd, but I like backwards compatibility! Postgres 8.4.1 -- CREATE VIEW v_members AS SELECT 1 as member_id, 100 as tenant_id, 3732 as conference_id, 200 as uid FROM (select 1 as uid_user, 2 as uid_contact) as m; SELECT u.tenan