Bill MacArthur <webmaster(at)dhs-club(dot)com> 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