Re: SQL state in log_line_prefix

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL state in log_line_prefix
Дата
Msg-id 20833.1241964475@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SQL state in log_line_prefix  (Guillaume Smet <guillaume.smet@gmail.com>)
Ответы Re: SQL state in log_line_prefix  (Guillaume Smet <guillaume.smet@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: SQL state in log_line_prefix
Следующее
От: Guillaume Smet
Дата:
Сообщение: Re: SQL state in log_line_prefix