On Wed, May 4, 2022 at 7:29 AM Petr Vejsada <pve@paymorrow.com> wrote:
We solved it (in our case) dropping the aggregate before upgrade and re-create in using new syntax in V14:
but pg_upgrade shouldn't fail on this.
I hope it can help to improve pg_upgrade process.
The release notes say explicitly that one needs to drop and recreate the affected functions. Thus, we know about the issue and to date our best solution is to have the user do exactly what you did (i.e., it is not something pg_upgrade is going to do for you). If you have an alternative solution to suggest that would help.