Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray

[Thomas Kellerer <shammat@xxxxxxx>]

Tom Lane schrieb am 22.05.2021 um 15:25:>> this aggregate can be created without problems on PG 13 and before:
> >     CREATE AGGREGATE array_accum(anyelement) (
> >         SFUNC = array_append,
> >         STYPE = anyarray,
> >         INITCOND = '{}'
> >     );
>
> > However, that fails with PG 14beta1 because array_append's
> > parameter are now (anycompatiblearray, anycompatible) while it used
> > to be (anyarray, anyelement).

> Yeah, you'll probably need to drop that aggregate and then recreate it
> after upgrading.

Hmm, that means dropping all views and functions that use that aggregate as well.
Quite cumbersome :(