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

From Guillaume Smet
Subject Re: SQL state in log_line_prefix
Date
Msg-id 1d4e0c10905100721o5d73cbdcp706d528078cca5d8@mail.gmail.com
Whole thread Raw
In response to Re: SQL state in log_line_prefix  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL state in log_line_prefix
Next
From: Pavel Stehule
Date:
Subject: Re: Implementation of GROUPING SETS (T431: Extended grouping capabilities)