Re: Row data is reflected in DETAIL message when constraints fail on insert/update - Mailing list pgsql-general

From Shay Rojansky
Subject Re: Row data is reflected in DETAIL message when constraints fail on insert/update
Date
Msg-id CADT4RqDYLKWxxHejU2ZE6Wmveo8x09Zf8aw4pdT-=0uU82Us=Q@mail.gmail.com
Whole thread Raw
In response to Re: Row data is reflected in DETAIL message when constraints fail oninsert/update  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Row data is reflected in DETAIL message when constraints fail oninsert/update
Re: Row data is reflected in DETAIL message when constraints fail oninsert/update
List pgsql-general
Shay here, maintainer of the Npgsql driver for .NET.

>> Is there a setting where i can disable the DETAIL field being populated
>> with row data?
>
> See:
>
>
> log_error_verbosity

While this is helpful, this does not seem to quite fit:

1. As this is about personal sensitive data (including conceivably authentication information), the fact that the default is to log seems problematic.
2. The TERSE setting also disables HINT, QUERY and CONTEXT.
3. There may be other information sent in the DETAIL messages which does not contain sensitive data. There's no reason to have that disabled along with the sensitive data.

 In other words, this isn't about verbosity, but about sensitive data. It seems like a specific knob for sensitive information may be required, which would be off by default and would potentially affect other fields as well (if relevant).

pgsql-general by date:

Previous
From: "pbj@cmicdo.com"
Date:
Subject: Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems
Next
From: Karsten Hilbert
Date:
Subject: Re: Row data is reflected in DETAIL message when constraints fail oninsert/update