Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> I was studying the PHV bug caused by join-removal and ran into an
> assertion failure with the query below, which is not related to
> join-removal. So start a new thread for it.
> ...
> Attached is a patch that teaches join_is_legal() to reject a join
> whose minimum parameterization includes an outer-join relid, if that
> outer join cannot be formed outside the join.
This looks like a good fix to me. Interesting that we've failed
to notice this bug up to now.
regards, tom lane