Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux