A customer of us recently wanted to separate user errors from system
errors as different teams are working on these 2 types of errors and
while they might want to ignore user errors (bad-written SQL queries
and so on), they want to be sure system errors are analyzed carefully.
A good way to differentiate the 2 types of errors is to use the SQL state.
Currently, the only way to have the SQL state in the standard log file
is to do verbose logging which is, well..., verbose.
I attached a patch which allows to add the SQL state code into the
log_line_prefix. I used %e (as in error) as %s is already used.
pgsql-hackers by date
|Next:||From: Guillaume Smet||Date: 2009-05-10 12:52:58|
|Subject: Re: SQL state in log_line_prefix|
|Previous:||From: Khee Chin||Date: 2009-05-10 05:24:24|
|Subject: Re: Show method of index|