Re: aggregate array broken in postgresql 15. - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: aggregate array broken in postgresql 15.
Date
Msg-id CAFj8pRCT0Fg6u4TiZ9boPXFoSoxOQBUhxRdYXbF9rrqGYD4WuQ@mail.gmail.com
Whole thread Raw
In response to aggregate array broken in postgresql 15.  (alias <postgres.rocks@gmail.com>)
Responses Re: aggregate array broken in postgresql 15.  (alias <postgres.rocks@gmail.com>)
List pgsql-hackers
Hi

čt 7. 4. 2022 v 12:30 odesílatel alias <postgres.rocks@gmail.com> napsal:


select version();
                                                                                version

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 15devel (Ubuntu 15~~devel~20220329.1030-1~680.git8cd7627.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
(1 row)

(END)
----------------
create or replace aggregate array_agg_mult(anycompatiblearray) (
sfunc = array_cat,
stype = anycompatiblearray,
initcond = '{}'
);
SELECT array_agg_mult(i)
FROM (VALUES (ARRAY[row(1,2),row(3,4)]), (ARRAY[row(5,6),row(7,8)])) as t(i);

ERROR:  42725: function array_agg_mult(record[]) is not unique
LINE 1: SELECT array_agg_mult(i)
               ^
HINT:  Could not choose a best candidate function. You might need to add explicit type casts.
LOCATION:  ParseFuncOrColumn, parse_func.c:570
Time: 1.292 ms


I tested your code on my clean pg 15 without any problem

Maybe you have an array_agg_mult with anyarray argument. If yes, then you have to drop this aggregate function.

Regards

Pavel




I installed postgresql 15, one week ago.
How to solve the above mentioned problem. Or since it was solved last week, I need to update postgresql?

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Should pg_dumpall dump ALTER SYSTEM settings?
Next
From: alias
Date:
Subject: Re: aggregate array broken in postgresql 15.