Re: SQL state in log_line_prefix

Поиск
Список
Период
Сортировка
От Guillaume Smet
Тема Re: SQL state in log_line_prefix
Дата
Msg-id 1d4e0c10905100721o5d73cbdcp706d528078cca5d8@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL state in log_line_prefix  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, May 10, 2009 at 4:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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?

We use http://www.postgresql.org/docs/8.3/interactive/errcodes-appendix.html
to sort the errors.

For example:
Class 22 — Data Exception -> user
Class 53 — Insufficient Resources -> system
Class XX — Internal Error -> system

It's not perfect but it's the best way we found to classify them at the moment.

--
Guillaume


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL state in log_line_prefix
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities)