On Sat, Jul 22, 2023 at 12:02 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> > Instead of fixing add_outer_joins_to_relids() to cope with child joins,
> > I'm wondering if we can build join relids for a child join from its
> > parent by adjust_child_relids, something like attached.
>
> That looks like a good solid solution. Pushed with a bit of
> editorialization --- mostly, that I put the test case into
> partition_join.sql where there's already suitable test tables.
Thanks for pushing it!
Thanks
Richard