Horton

Re: control max length of parameter values logged

Keisuke Kuroda <keisuke.kuroda.3862@gmail.com>

View thread View on postgr.es
From: keisuke kuroda <keisuke.kuroda.3862@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, Alexey Bashtanov <bashtanov@imap.cc>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-03-18T05:04:06Z
Lists: pgsql-hackers 
Hi,

BIND parameter truncation is good to me.
Logs could be very hard to read due to
the very long parameters recorded.

Now, parameter is extracuted from left.
e.g. "AAAA-BBBB-CCCC-DDDD-EEEE" to "AAAA-BBBB-CCCC..."

Is not necessary from right?
e.g. "AAAA-BBBB-CCCC-DDDD-EEEE" to "...CCCC-DDDD-EEEE"

It is sometimes nice to be able to check
the last of strings. For example, if there
are difference only in the last of strings
of many parameters.

Best Regards,
Keisuke Kuroda

Commits

  1. Improve user control over truncation of logged bind-parameter values.