From: | Ian Pilcher <arequipeno(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Range for user-defined SQLSTATE codes |
Date: | 2013-01-26 04:25:36 |
Message-ID: | kdvlrt$acr$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)com
Sometimes there's nothing left to do but crash and burn...or die trying.
========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Gavan Schneider | 2013-01-26 05:07:36 | Re: Throttling Streamming Replication |
Previous Message | Scott Marlowe | 2013-01-25 20:37:35 | Re: Throttling Streamming Replication |