Re: FDW RTE join pushdown fails to create plan with aggregates - Mailing list pgsql-hackers

From Richard Guo
Subject Re: FDW RTE join pushdown fails to create plan with aggregates
Date
Msg-id CAMbWs4-aTDd5Nj9O_cedS25WVheUp0Uh_ESPnLAiMAAycWK+tQ@mail.gmail.com
Whole thread
In response to Re: FDW RTE join pushdown fails to create plan with aggregates  (Kirill Reshke <reshkekirill@gmail.com>)
List pgsql-hackers
On Sat, Sep 26, 2026 at 1:28 AM Kirill Reshke <reshkekirill@gmail.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



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Row pattern recognition
Next
From: Greg Burd
Date:
Subject: Re: Tepid: selective index updates for heap relations