Re: SQL state in log_line_prefix

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