Thread: BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error

The following bug has been logged on the website:

Bug reference:      17034
Logged by:          Adam Rauch
Email address:      adam@labkey.com
PostgreSQL version: 14beta1
Operating system:   Windows 10
Description:

The DDL below has executed correctly on every PostgreSQL version through
13.x. In 14 beta 1, it produces: "ERROR:  function array_append(anyarray,
anyelement) does not exist  SQL state: 42883"

CREATE AGGREGATE core.array_accum (anyelement)
(
  sfunc = array_append,
  stype = anyarray,
  initcond = '{}'
);

We long ago stopped using this aggregate function (switched to built-in
functions array_agg and string_agg), so we can simply remove this DDL (i.e.,
we don't care if it's fixed or not). But other systems may be affected by
this change. If nothing else, a mention in the release notes would be
helpful.

On Wed, 26 May 2021 at 14:55, PG Bug reporting form
<noreply@postgresql.org> wrote:
> We long ago stopped using this aggregate function (switched to built-in
> functions array_agg and string_agg), so we can simply remove this DDL (i.e.,
> we don't care if it's fixed or not). But other systems may be affected by
> this change. If nothing else, a mention in the release notes would be
> helpful.

Thanks for the report.  Quite a few other people found and reported
this and it looks like we'll be adding it to the release notes at some
point. See [1].

David

[1] https://www.postgresql.org/message-id/20210520232922.GG3676@telsasoft.com