Re: FDW RTE join pushdown fails to create plan with aggregates

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Subject: Re: FDW RTE join pushdown fails to create plan with aggregates
Date: 2026-09-28 01:01:39
Message-ID: CAMbWs4-aTDd5Nj9O_cedS25WVheUp0Uh_ESPnLAiMAAycWK+tQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Sep 26, 2026 at 1:28 AM Kirill Reshke <reshkekirill(at)gmail(dot)com> wrote:
> Looks like I wrongly blamed 0ee83dd4a99 as root cause.
> On 8e11859102f947e6145acdd809e5cdcdfbe90fa5 (eager aggregation), I got

> ANALYZE
> ERROR: Aggref found where not expected

FWIW, this is a duplicate of the bug reported by Robert (finding2 in
[1]), and a proposed fix was provided there.

[1] https://postgr.es/m/CA+Tgmob7iSM9YkRM44VjUDuaCchW-fY54MV5njpTZTL9uNyV4w@mail.gmail.com

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Tatsuo Ishii 2026-09-28 00:53:42 Re: Row pattern recognition