Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"
Дата
Msg-id 18419.1486075685@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14524: Commands compare with nested subquery expressions failwith "should not reference subplan var"  (crvv.mail@gmail.com)
Ответы Re: [BUGS] BUG #14524: Commands compare with nested subqueryexpressions fail with "should not reference subplan var"
Список pgsql-bugs
crvv.mail@gmail.com writes:
> SELECT '1' IN (SELECT (SELECT '1'::BOOL))
> Error message is "plan should not reference subplan's variable".

Seems to be a problem with pasting on Material nodes at the last minute.
As a short-term workaround, you might try turning off enable_material.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления: