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"  (CR VV <crvv.mail@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] Parser failed to return an error
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least9.5)?