Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"
Date
Msg-id 18419.1486075685@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14524: Commands compare with nested subquery expressions failwith "should not reference subplan var"  (crvv.mail@gmail.com)
Responses Re: [BUGS] BUG #14524: Commands compare with nested subqueryexpressions fail with "should not reference subplan var"  (CR VV <crvv.mail@gmail.com>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] Parser failed to return an error
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least9.5)?