Guillaume Smet wrote:
Hi -hackers, 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. Any comment?
If we're going to do this I think it needs to be added to CSV log output too.
cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
