SQL Error Code Anomaly

Hi,

During my work on the binary stream patch, I came across this:

The error code PSQLState.NUMERIC_CONSTANT_OUT_OF_RANGE = 42820 is not
defined in

http://www.postgresql.org/docs/9.1/interactive/errcodes-appendix.html

Is this a concern? Is there a list of error codes defined by the JDBC
driver somewhere? I did not see anything at first glance.

I did not come across 42820 in the SQL standard either. Only that 42xxx
is _syntax error or access rule violation_.

A simple shell one liner shows these error codes used by the JDBC driver
but not documented in Postgres:

0100E
07006
08S01
42820
42821
60000
99999

I have not investigated this further.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/