Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #10587: ERROR: variable not found in subplan target list - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #10587: ERROR: variable not found in subplan target list
Date
Msg-id 13434.1402364359@sss.pgh.pa.us
Whole thread Raw
In response to BUG #10587: ERROR: variable not found in subplan target list  (geoff@sea-incorporated.com)
Responses Re: BUG #10587: ERROR: variable not found in subplan target list  (Geoff Speicher <geoff@sea-incorporated.com>)
List pgsql-bugs
Tree view 
geoff@sea-incorporated.com writes:
> The following SQL has been verified to yield a planner error in 9.2.2 and
> 9.2.8 (maybe others), but the query succeeds in 9.3.4.

Thanks for the compact test case!  I believe this patch fixes it:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=187ae17300776f48b2bd9d0737923b1bf70f606e

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10588: inconsistent permissions for InformationSchema tables..
Next
From: zhangzq
Date:
Subject: Re: Many processes blocked at ProcArrayLock!