Re: view + explain + index scan -> bogus varno: 65001 (with some variations)

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

In response to

Browse pgsql-bugs by date

  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)