Re: assertion failure with unique index + partitioning + join

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Tender Wang <tndrwang@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Alexander Kuzmenkov <akuzmenkov@tigerdata.com>

Date: 2026-06-22T06:37:04Z

Lists: pgsql-hackers

On Fri, Jun 19, 2026 at 12:03 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Patch updated.

I've committed this patch after some cosmetic tweaks.  Thanks for the
report (and well-contained repro), and thanks for the reviews.

- Richard

Commits

Strip removed-relation references from PlaceHolderVars at join removal
- e0252679559a 18 (unreleased) landed
- 9a60f295bcb1 19 (unreleased) landed
Clean up remove_rel_from_query() after self-join elimination commit
- 20efbdffeb64 19 (unreleased) cited
Fix incorrect handling of subquery pullup
- cc5d98525d43 18.0 cited