pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error
2+ messages / 2 participants
[nested] [flat]
* BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error
@ 2021-05-25 22:58 PG Bug reporting form <noreply@postgresql.org>
2021-05-27 06:48 ` Re: BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error David Rowley <dgrowleyml@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-05-25 22:58 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: adam@labkey.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error
2021-05-25 22:58 BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error PG Bug reporting form <noreply@postgresql.org>
@ 2021-05-27 06:48 ` David Rowley <dgrowleyml@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David Rowley @ 2021-05-27 06:48 UTC (permalink / raw)
To: adam@labkey.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-05-27 06:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-25 22:58 BUG #17034: Creating aggregate function based on array_append now results in "function does not exist" error PG Bug reporting form <noreply@postgresql.org>
2021-05-27 06:48 ` David Rowley <dgrowleyml@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox