Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable
Date
Msg-id 14881.1240678352@sss.pgh.pa.us
Whole thread Raw
In response to Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable  (Daniel Grace <dgrace@wingsnw.com>)
Responses Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable  (Daniel Grace <dgrace@wingsnw.com>)
List pgsql-bugs
Tree view 
Daniel Grace <dgrace@wingsnw.com> writes:
> The following nonsensical query causes PostgreSQL to fail with ERROR: plan
> should not reference subplan's variable.  (This was stripped down from an
> 'useful' query that triggered the same bug).  First encountered on 8.3.4,
> reproduced on 8.3.7

Patch is here:
http://archives.postgresql.org/pgsql-committers/2009-04/msg00277.php

I still think that it won't affect you once you have the query logic
straight, though.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Larry Silvermintz"
Date:
Subject: PGAdminIII Query Tool Edit Window Key Commands stopped working between 1.0 and 1.10.0 beta.
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: BUG #4772: The server is hanging