Function any_value(text) not found pg 15

[hivs77]

Hello,

I tried to generate the report in PostgreSQL 15 and got the following error:

psql -U postgres test -X -f gather_report.sql > /tmp/GatherReport.html psql:gather_report.sql:195: ERROR: no existe la función any_value(text) LÍNEA 4: SELECT p.relname "Partitioned Table", CONCAT(any_value(c.re... ^ SUGERENCIA: Ninguna función coincide en el nombre y tipos de argumentos. Puede ser necesario agregar conversión explícita de tipos. psql:gather_report.sql:483: ERROR: no existe la función any_value(text) LÍNEA 38: ...),count(*) FILTER (WHERE source = 'command line'),any_value(... ^ SUGERENCIA: Ninguna función coincide en el nombre y tipos de argumentos. Puede ser necesario agregar conversión explícita de tipos.

When I checked online, I found that

PostgreSQL 15 does not natively include an ANY_VALUE() aggregate function. This function was introduced in PostgreSQL 16.

thank you

[jobinau]

Hi @hivs77 ,
Thank you for the feedback.
The premise is that the lab where we do the analyse of the collected data is running one of the latest versions.
This is yet another reason to split the data collection and analysis. Because the data analysis might need complex Analytical SQL statements.
I mean, we can collect data from any PostgreSQL version (using gather.sql), but for analysis and report generation (gather_report.sql), we need a new version with modern SQL features.

If you don't have a new PG version in your lab environment, please try using the Docker option : https://github.com/jobinau/pg_gather/blob/main/generate_report.sh (Demo : https://www.youtube.com/watch?v=amPQRzz5D8Y)
This spins up a temporary PG17 instance.

Thank you,
Jobin.