Re: log bind parameter values on error - Mailing list pgsql-hackers

From Tom Lane
Subject Re: log bind parameter values on error
Date
Msg-id 11425.1575927321@sss.pgh.pa.us
Whole thread Raw
In response to Re: log bind parameter values on error  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Greg Stark <stark@mit.edu> writes:
> On Mon, 9 Dec 2019 at 15:17, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Meh ... people will inevitably complain that they needed to see the
>> whole value, and we'll end up having to add another configuration
>> variable.  Let's not go there just yet.

> I haven't been following this whole thread but my initial reaction is
> that this particular configuration parameter would actually carry it's
> weight.

Possibly so.  I was mainly objecting to changing existing behaviors
without offering any configuration recourse for getting back the
existing behavior.

Although it would be sensible to allow logging of parameter values
to be controlled by a new GUC, it's less clear to me that the same GUC
ought to control what plpgsql's language feature print_strict_params
does.  So there would be room for discussion about that even if we
agreed on making this configurable.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [Proposal] Level4 Warnings show many shadow vars
Next
From: Greg Stark
Date:
Subject: Re: VACUUM memory management