pg_plan_advice: Avoid assertion failure with partitionwise aggregate.

Robert Haas <rhaas@postgresql.org>

Commit: e2ee95233cab32a0d5fe64925aefe816c13dbbc0
Author: Robert Haas <rhaas@postgresql.org>
Date: 2026-03-30T13:58:25Z
pg_plan_advice: Avoid assertion failure with partitionwise aggregate.

An Append node that is part of a partitionwise aggregate has no
apprelids. If such a node was elided, the previous coding would
attempt to call unique_nonjoin_rtekind() on a NULL pointer, which
leads to an assertion failure. Insert a NULL check to prevent that.

Reported-by: Alexander Lakhin <exclusion@gmail.com>
Discussion: http://postgr.es/m/0afba1ce-c946-4131-972d-191d9a1c097c@gmail.com

Files

PathChange+/−
contrib/pg_plan_advice/pgpa_scan.c modified +7 −0

Discussion