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

On Fri, Mar 23, 2012 at 11:04 PM, Mark Murawski
<markm-lists(at)intellasoft(dot)net> 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 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.

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación