pg_upgrade (12->14) fails on aggregate

From: Petr Vejsada <pve(at)paymorrow(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pg_upgrade (12->14) fails on aggregate
Date: 2022-05-04 13:05:32
Message-ID: 3383880.QJadu78ljV@vejsadalnx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs pgsql-hackers

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.




Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2022-05-04 14:34:15 Re: pg_upgrade (12->14) fails on aggregate
Previous Message Alvaro Herrera 2022-05-04 10:17:46 Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2022-05-04 13:13:31 Re: Add pg_strtoupper and pg_strtolower functions
Previous Message Daniel Gustafsson 2022-05-04 12:19:01 Re: testclient.exe installed under MSVC