Range for user-defined SQLSTATE codes
| От | Ian Pilcher |
|---|---|
| Тема | Range for user-defined SQLSTATE codes |
| Дата | |
| Msg-id | kdvlrt$acr$1@ger.gmane.org обсуждение исходный текст |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: