From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: view + explain + index scan -> bogus varno: 65001 (with some variations) |
Date: | 2011-07-03 05:40:51 |
Message-ID: | 18551.1309671651@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:
> On Fri, Jul 1, 2011 at 3:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> FWIW, I can't reproduce such a failure with current 8.4 branch (nor any
>> other).
> Try adding:
> set enable_mergejoin = false;
Thanks, that did it. I've repaired the symptom exposed here:
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=d3d3ec0d890412f3b39a70e8fd08edf17e3c9f7c
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=789d3d4541e95c6079a55196bd63a6ab90e57c7c
However, while I see how this could generate "bogus varno: 65001", I'm
not entirely sure that the same issue explains your other report of
"bogus varattno for OUTER var". If you can still reproduce that,
please send a test case.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2011-07-03 11:19:04 | Re: BUG #6082: server segfault - pg_stat_reset_shared(null) |
Previous Message | Jon Nelson | 2011-07-03 03:16:16 | Re: view + explain + index scan -> bogus varno: 65001 (with some variations) |