Bill MacArthur <[email protected]> writes:
> Update, I started placing primary keys on the testcase tables and watched the
> planner output. Once I put a PK on one of the tables in particular, the
> planner revised the plan to use the PK. At that point, the results become
> erroneous as the planner also moves another filter evaluation to an earlier
> point at which time I don't think it has the data to make the decision.
Curious ...
> I can still finish up with the test case if you like, but here is a
> highlight. The first VIEW, which I did not originally post is this:
Test case, please.
regards, tom lane
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs