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  (Daniel Grace <dgrace@wingsnw.com>)
Список 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 по дате отправления:

Предыдущее
От: "Larry Silvermintz"
Дата:
Сообщение: PGAdminIII Query Tool Edit Window Key Commands stopped working between 1.0 and 1.10.0 beta.
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: BUG #4772: The server is hanging