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