Re: SQL state in log_line_prefix - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SQL state in log_line_prefix
Date
Msg-id 20833.1241964475@sss.pgh.pa.us
Whole thread Raw
In response to SQL state in log_line_prefix  (Guillaume Smet <guillaume.smet@gmail.com>)
Responses Re: SQL state in log_line_prefix  (Guillaume Smet <guillaume.smet@gmail.com>)
List pgsql-hackers
Guillaume Smet <guillaume.smet@gmail.com> writes:
> 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.

This might or might not be worth doing, but it seems pretty nearly
entirely useless for the claimed purpose.  What is your division between
"user errors" and "system errors", and how will the SQLSTATE help you
make that?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: SQL state in log_line_prefix
Next
From: Guillaume Smet
Date:
Subject: Re: SQL state in log_line_prefix