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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: adam(at)labkey(dot)com
Subject: BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error
Date: 2021-05-25 22:58:31
Message-ID: 17034-065ef2f6a560c7cb@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17034
Logged by: Adam Rauch
Email address: adam(at)labkey(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2021-05-26 02:14:59 Re: BUG #17032: wrong password cause double connect and double error
Previous Message Tom Lane 2021-05-25 14:12:47 Re: BUG #17032: wrong password cause double connect and double error