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

2019-06-24 Thread Shay Rojansky
Shay Rojansky writes: >> I don't think that's true - schema information (table, column names) >> definitely seems like it's in a different category than table contents. > > You're not visualizing this with the appropriate amount of paranoia: just > becaus

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

2019-06-20 Thread Shay Rojansky
>> A specifig knob for "sensitive data" cannot be supplied by >> PostgreSQL because it cannot know beforehand what information >> will be considered sensitive under a given, future, usage >> scenario. > Yeah, it's fairly hard to see how we could respond to this complaint > without lobotomizing our

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

2019-06-20 Thread Shay Rojansky
Karsten, >> 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). > > A specifig knob for "sensitive dat

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

2019-06-20 Thread Shay Rojansky
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: > > https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT > > log_error_verbosity While this is helpful,