Re: Row data is reflected in DETAIL message when constraints fail on insert/update

Поиск
Список
Период
Сортировка
От Shay Rojansky
Тема Re: Row data is reflected in DETAIL message when constraints fail on insert/update
Дата
Msg-id CADT4RqDYLKWxxHejU2ZE6Wmveo8x09Zf8aw4pdT-=0uU82Us=Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Row data is reflected in DETAIL message when constraints fail oninsert/update  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Row data is reflected in DETAIL message when constraints fail oninsert/update  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: Row data is reflected in DETAIL message when constraints fail oninsert/update  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: "pbj@cmicdo.com"
Дата:
Сообщение: Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Row data is reflected in DETAIL message when constraints fail oninsert/update