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

2021-05-22 Thread Thomas Kellerer
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 ar

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

2021-05-22 Thread Tom Lane
Thomas Kellerer 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 pa

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

2021-05-22 Thread Thomas Kellerer
Hello, 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 (anycompatiblearra