Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Grace <dgrace(at)wingsnw(dot)com>
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 16:52:32
Message-ID: 14881.1240678352@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Devrim GÜNDÜZDate: 2009-04-25 17:25:14
Subject: Re: BUG #4772: The server is hanging
Previous:From: Larry SilvermintzDate: 2009-04-25 16:02:42
Subject: PGAdminIII Query Tool Edit Window Key Commands stopped working between 1.0 and 1.10.0 beta.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group