Richard Guo c9231b776b Don't pass grouped relations to FDWs ...

build_grouped_rel() makes a flat copy of the input relation, including
its FDW fields.  As a result, when building a grouped join relation
for eager aggregation, add_paths_to_joinrel() called the FDW's
GetForeignJoinPaths for it.  postgres_fdw then failed with "Aggref
found where not expected" on the partial Aggrefs in the target list,
and in any case it would have treated a partially aggregated input as
a plain foreign scan.

FDWs are not prepared to handle grouped relations, so clear serverid,
fdwroutine and fdw_private in build_grouped_rel().

Reported-by: Robert Haas <robertmhaas@gmail.com>
Author: Richard Guo <guofenglinux@gmail.com>
Discussion: https://postgr.es/m/CA+Tgmob7iSM9YkRM44VjUDuaCchW-fY54MV5njpTZTL9uNyV4w@mail.gmail.com
Backpatch-through: 19

2026-10-06 08:51:36 +09:00

..

postgres_fdw.sql

Don't pass grouped relations to FDWs

2026-10-06 08:51:36 +09:00

query_cancel.sql

postgres_fdw: re-issue cancel requests a few times if necessary.

2024-12-23 15:14:30 -05:00