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> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: pve@paymorrow.com, pgsql-bugs@lists.postgresql.org
Subject: Re: pg_upgrade (12->14) fails on aggregate
In-Reply-To: <3383880.QJadu78ljV@vejsadalnx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox