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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable
Дата
Msg-id 14881.1240678352@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable  (Daniel Grace <dgrace@wingsnw.com>)
Ответы Re: Query with aggregate over subselects fails with ERROR: plan should not reference subplan's variable
Список pgsql-bugs
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 по дате отправления: