Am 03.09.25 21:07 schrieb(en) Tom Lane:
> There isn't any provision for limiting the length of source queries
> quoted in the log.
I see, thanks for the clarification. IMHO, it would be nice to have such an option, though…
> Had your user sent the bytea value as a query
> parameter, then log_parameter_max_length[_on_error] would have
> applied, but this looks like the value was just inline in the query.
I can confirm that the limitation is applied when I call PQexecParams() from a little c test application with the data
includedin the paramValues array. The overlong log lines result from queries in a Python script using the psycopg2
module– no idea how this component formats the query.
Thanks again,
Albrecht.