On Fri, Jul 1, 2011 at 3:27 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Jon Nelson <jnelson+pg...@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).
I managed to reproduce the problem on 9.0.3 as well. Try adding: set enable_mergejoin = false; -- Jon -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
