Justin Pryzby <pryzby@telsasoft.com> writes:
> On Fri, Oct 11, 2019 at 10:48:37AM -0400, Tom Lane wrote:
>> Could you provide a self-contained test case please?
> [ test case ]
Oh, this is the same issue Amit described in
https://www.postgresql.org/message-id/flat/CA%2BHiwqG2WVUGmLJqtR0tPFhniO%3DH%3D9qQ%2BZ3L_ZC%2BY3-EVQHFGg%40mail.gmail.com
namely that we're not generating EquivalenceClass members corresponding
to sub-joins of a partitionwise join.
Are you interested in helping to test the patches proposed there?
regards, tom lane