Thomas Kellerer <shammat(at)gmx(dot)net> writes:
> 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.
regards, tom lane