Re: BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: olgaantonova2.0@yandex.ru
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-03-13T14:43:04Z
Lists: pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> How to reproduce the problem:
> 1. Generate test data by pgbench with scale_factor 10
> pgbench -i -s 10 -U postgres -p 5434 -d test
> 2. Run query in test database
> select bid, array_agg(ROW(aid,abalance)) from pgbench_accounts group by
> bid;

This is presumably the same issue recently reported at

https://postgr.es/m/flat/atLI5Kce2ie1zcYjU0w_kjtVaxiYbYGTihrkLDmGZQnRDD4pnXukIATaABbnIj9pUnelC4ESvCXMm4HAyHg-v61XABaKpERj0A2IXzJZM7g=@dineserve.com

			regards, tom lane