From: Petr Vejsada <pve@paymorrow.com>
To: pgsql-bugs@lists.postgresql.org
Subject: pg_upgrade (12->14) fails on aggregate
Date: Wed, 04 May 2022 15:05:32 +0200
Message-ID: <3383880.QJadu78ljV@vejsadalnx>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"
Archived-At: 
 <https://www.postgresql.org/message-id/3383880.QJadu78ljV%40vejsadalnx>
Precedence: bulk

Hi Team,

we experienced pg_upgrade failing when attempted to upgrade from 12.10 to 14.2 
(on AWS RDS)

We had this aggregate:

CREATE AGGREGATE public.array_accum(anyelement) ( SFUNC = array_append, STYPE 
= anyarray, INITCOND = '{}');

Syntax in version 14 is changed (we didn't try to run version 13)

We solved it (in our case) dropping the aggregate before upgrade and re-create 
in using new syntax in V14:

CREATE AGGREGATE public.array_accum(anycompatible) ( SFUNC = array_append, 
STYPE = anycompatiblearray, INITCOND = '{}');

but pg_upgrade shouldn't fail on this.

I hope it can help to improve pg_upgrade process.

Thanks.

--
Best
Petr