Re: Subquery with toplevel reference used to work in pg 8.4 - Mailing list pgsql-bugs

From Jaime Casanova
Subject Re: Subquery with toplevel reference used to work in pg 8.4
Date
Msg-id CAJKUy5gd6kR7NuPwVjzW0AkKjLR8J5JNZmQZ=stCck+uhfCcfQ@mail.gmail.com
Whole thread Raw
In response to Subquery with toplevel reference used to work in pg 8.4  (Mark Murawski <markm-lists@intellasoft.net>)
List pgsql-bugs
On Fri, Mar 23, 2012 at 11:04 PM, Mark Murawski
<markm-lists@intellasoft.net> wrote:
>
> ERROR: =A0Upper-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 see an uplevel Var, Aggref, or PlaceHolderVar here,
that was a long time ago, so complain instead of ignoring them.
"""

the query seems useless but valid to me...
just removing this check and the assert in
find_placeholder_info():placeholder.c seems to make this query behave
normally again.

--=20
Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n

pgsql-bugs by date:

Previous
From: Mark Murawski
Date:
Subject: Subquery with toplevel reference used to work in pg 8.4
Next
From: Tom Lane
Date:
Subject: Re: Subquery with toplevel reference used to work in pg 8.4