error codes table

Started by Peter Eisentrautalmost 15 years ago4 messagesdocs
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

Ref: http://developer.postgresql.org/pgdocs/postgres/errcodes-appendix.html

It seems to me that the second and the third column in that table are
redundant. The third is just the second with underscores and lower-case
letters. I find this pretty confusing, first because of the sheer
(apparent) volume of information, and second because one might be led to
believe that there is a difference between the columns hidden somewhere.

I suppose at one point it was the intent that the second column contain
a human-readable explanation, but that hasn't been realized.

Also, the sentence above the table "The PL/pgSQL condition name for each
error code is the same as the phrase shown in the table, with
underscores substituted for spaces. For example, code 22012, DIVISION BY
ZERO, has condition name DIVISION_BY_ZERO." is redundant or obsolete.

I think we should just remove the second column from the table and
rephrase the paragraph above it accordingly. At some point in the
future we could introduce a separate optional data field that adds
actual additional information about the error codes.

#2Ferdian Zaman
fer_zaman@yahoo.com
In reply to: Peter Eisentraut (#1)
please unsubscribe me

________________________________
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-docs <pgsql-docs@postgresql.org>
Sent: Friday, May 20, 2011 4:04 AM
Subject: [DOCS] error codes table

Ref: http://developer.postgresql.org/pgdocs/postgres/errcodes-appendix.html

It seems to me that the second and the third column in that table are
redundant.  The third is just the second with underscores and lower-case
letters.  I find this pretty confusing, first because of the sheer
(apparent) volume of information, and second because one might be led to
believe that there is a difference between the columns hidden somewhere.

I suppose at one point it was the intent that the second column contain
a human-readable explanation, but that hasn't been realized.

Also, the sentence above the table "The PL/pgSQL condition name for each
error code is the same as the phrase shown in the table, with
underscores substituted for spaces. For example, code 22012, DIVISION BY
ZERO, has condition name DIVISION_BY_ZERO." is redundant or obsolete.

I think we should just remove the second column from the table and
rephrase the paragraph above it accordingly.  At some point in the
future we could introduce a separate optional data field that adds
actual additional information about the error codes.

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

In reply to: Peter Eisentraut (#1)
Re: error codes table

Em 19-05-2011 18:04, Peter Eisentraut escreveu:

I think we should just remove the second column from the table and
rephrase the paragraph above it accordingly. At some point in the
future we could introduce a separate optional data field that adds
actual additional information about the error codes.

+1. Moreover, I suggest to lowercase condition names in PL/pgSQL documentation
because it is inconsistent (I know that it says that the condition names are
case-sensitive but first time I saw them I've started thinking they could be
different macros but they weren't).

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

#4Kevin Grittner
Kevin.Grittner@wicourts.gov
In reply to: Ferdian Zaman (#2)
Re: please unsubscribe me

Peter Eisentraut

To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

Ferdian Zaman wrote:

Did you try visiting the web page mentioned in the post to which
you replied? If so, did you have a problem unsubscribing? If so,
please describe what happened so we can fix it.

-Kevin