On Sat, Jul 22, 2023 at 12:02 AM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Richard Guo <guofengli...@gmail.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