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 :(