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

From Thomas Kellerer
Subject Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray
Date
Msg-id 45750910-0ffc-8128-a72a-cf47989bed4c@gmx.net
Whole thread Raw
In response to Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray  (Tom Lane)
List pgsql-general
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 :(





pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pgbackrest - hiding the encryption password
Next
From: Adrian Klaver
Date:
Subject: Re: The contents of the pg_timezone_names view bring some surprises