syntax error at or near ")" at pg_profile 4.8 or 4.10

[gregoryusip]

Hi there,

I got an issue when I try to take_sample using pg_profile version 4.8 or 4.10.

for your information, I'm using EDB version 17.5, dblink version 1.2, pg_stat_statements version 1.11, pg_profile version 4.8 (got the same error with version 4.10), and plpgsql 1.0.

Below is the error log when i do "select * from schema.take_sample('local');"

                                                   result                                                       |   elapsed

--------------------------------------------------------------------------------------------------------------------+-------------
syntax error at or near ")" +| 00:00:00.15
while executing query on dblink connection named "server_connection" +|
PL/pgSQL function collect_pg_stat_statements_stats(jsonb,integer,integer,integer) line 832 at FOR over SELECT rows+|
SQL statement "SELECT collect_pg_stat_statements_stats(server_properties, sserver_id, s_id, topn)" +|
PL/pgSQL function take_sample(integer,boolean) line 624 at PERFORM +|
PL/pgSQL function take_sample(name,boolean) line 16 at assignment +|
|

Can you please help this issue?

Thank you,

GIP