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

From Tom Lane
Subject Re: view + explain + index scan -> bogus varno: 65001 (with some variations)
Date
Msg-id 4207.1309552056@sss.pgh.pa.us
Whole thread Raw
In response to view + explain + index scan -> bogus varno: 65001 (with some variations)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Responses Re: view + explain + index scan -> bogus varno: 65001 (with some variations)  (Jon Nelson <jnelson+pgsql@jamponi.net>)
List pgsql-bugs
Jon Nelson <jnelson+pgsql@jamponi.net> writes:
> With 8.4.7, I ran into an issue trying to explain a VIEW query.
> After much effort, I distilled the query down and was able to
> replicate the issue with a test script, included below.

FWIW, I can't reproduce such a failure with current 8.4 branch (nor any
other).  It's possible this has been fixed since 8.4.7, but I don't
immediately see any commit log entries that look related.  Another
possibility is that there's something nondefault about your environment,
for instance nondefault values for planner cost parameters, and the
example depends on those to work (or rather, not work).

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stewart Fritts
Date:
Subject: Re: BUG #6084: When Updating Tables with Select Into
Next
From: Tom Lane
Date:
Subject: Re: Bug with plpgsql, temp tables and TOAST?