Re: Q: limit the length of log file entries? - Mailing list pgsql-general

From Albrecht Dreß
Subject Re: Q: limit the length of log file entries?
Date
Msg-id TFULP3P6.EN64L3JH.HKBKS5SI@5MABK74K.JEDAXO5P.UTRFWLFY
Whole thread Raw
In response to Re: Q: limit the length of log file entries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Q: limit the length of log file entries?
List pgsql-general
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.
Attachment

pgsql-general by date:

Previous
From: Albrecht Dreß
Date:
Subject: Re: Q: limit the length of log file entries?
Next
From: Adrian Klaver
Date:
Subject: Re: Q: limit the length of log file entries?