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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray
Date: 2021-05-22 13:25:02
Message-ID: 229062.1621689902@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Kellerer <shammat(at)gmx(dot)net> 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 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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-05-22 15:09:41 Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
Previous Message Thomas Kellerer 2021-05-22 12:32:57 PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray