Re: Partial aggregates pushdown - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Partial aggregates pushdown
Date
Msg-id 3285493.1680921849@sss.pgh.pa.us
Whole thread Raw
In response to Re: Partial aggregates pushdown  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Partial aggregates pushdown  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> On Fri, Apr  7, 2023 at 09:55:00PM -0400, Tom Lane wrote:
>> Uh, what?  Why would we not be able to tell from the remote server's
>> version number whether it has this ability?

> The issue is not a mismatch of postgres_fdw versions but the extension
> versions and whether the partial aggregate functions exist on the remote
> side, e.g., something like a PostGIS upgrade.

postgres_fdw has no business pushing down calls to non-builtin functions
unless the user has explicitly authorized that via the existing
whitelisting mechanism.  I think you're reinventing the wheel,
and not very well.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Kirk Wolak
Date:
Subject: Re: Commitfest 2023-03 starting tomorrow!
Next
From: Tom Lane
Date:
Subject: Re: longfin missing gssapi_ext.h