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 22335.1240619893@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
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

Hmmm ... I guess something is getting confused about the level of query
nesting.  FWIW, you can avoid the bug in these two examples by omitting
the inner "SELECT" keyword, which is useless anyway.  Perhaps it is
needed in your real query though ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Daniel Grace
Date:
Subject: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable
Next
From: Daniel Grace
Date:
Subject: Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable