------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 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?