From: | Geoff Speicher <geoff(at)sea-incorporated(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #10587: ERROR: variable not found in subplan target list |
Date: | 2014-06-10 13:42:34 |
Message-ID: | CAFMeXObkcERwnOY_aq438EhFj0oXC71cRgdHTkyV9gB-6+drNw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, Jun 9, 2014 at 9:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> geoff(at)sea-incorporated(dot)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
>
Thanks Tom! Your patch fixes the test case that I submitted, and it also
fixes a more complicated query of a similar structure that was returning
incorrect results rather than throwing an error.
You and I met briefly in San Diego at OSCON 2002. Greetings from Scranton
and I hope you are well!
Geoff
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2014-06-10 13:48:42 | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |
Previous Message | Serge Negodyuck | 2014-06-10 09:26:27 | Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby |