Thread: Range for user-defined SQLSTATE codes

Range for user-defined SQLSTATE codes

From
Ian Pilcher
Date:
I can't be the first person (or even the 10,000th) to want to define my
own SQLSTATE codes when raising errors in a stored procedure.  I've
just tested doing so in a PL/pgSQL function access via JDBC, and I had
no problem retrieving the non-standard state from the SQLException.  (I
used 'WWWWW' and 'ZZZZZ' as my tests.)

Is there anything like a standard range -- formal or otherwise -- for
such codes?  A best practice?  A general consensus?  A half-painted
bike shed?

Thanks!

--
========================================================================
Ian Pilcher                                         arequipeno@gmail.com
Sometimes there's nothing left to do but crash and burn...or die trying.
========================================================================



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