Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable

From: Daniel Grace <dgrace(at)wingsnw(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable
Date: 2009-04-25 18:46:20
Message-ID: 8a80df380904251146k43d481a7s4123450fc2d2f2c2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Apr 25, 2009 at 9:52 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Daniel Grace <dgrace(at)wingsnw(dot)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.
>
Thanks for the info. I've since fixed the query, so you are right in that
regard ;)

-- Daniel Grace

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Larry Silvermintz 2009-04-26 00:46:45 Solution: : Bug Report: PGAdminIII Query Tool Edit Window Key Commands stopped working between 1.0 and 1.10.0 beta.
Previous Message Devrim GÜNDÜZ 2009-04-25 17:25:14 Re: BUG #4772: The server is hanging