Re: Huh? ErrorCode/SQLstate are null?

Dror,

The error messages are sort of inline with the backend server code,
however they can be translated (see src/backend/po/*).

The error strings probably won't change between releases, however
depending on language settings you may end up with totally different
strings for the same error condition.

thanks,
--Barry


Dror Matalon wrote:
 > Hi,
 >
 > Follow up to this question, not really JDBC specific. Is there a
 > specific centralized location for the error messages, or are these just
 > inline in different parts of the postmaster code?
 > Also, how likely is it that the error string would change between
 > versions?
 >
 > In other words, if I want to check for
 >  Relation "adb_email" does not exist
 > So that I can conver it to
 >     There is no "adb_email" table in the database
 >
 > Would I be running the chance that in the next version the error message
 > is going to change?
 > Is this a bad idea?
 >
 >
 > On Wed, Oct 02, 2002 at 09:27:31AM -0700, Barry Lind wrote:
 >
 >>Please see the many past posts in the archives on this topic.  But the
 >>short answer is: the postgres server doesn't yet support error codes and
 >>therefore neither does the jdbc driver.  It is on the todo list for both
 >>however, but no one has yet stepped up to implement it.
 >>
 >>--Barry
 >>
 >>beh@icemark.net wrote:
 >>
 >>>Hi there,
 >>>
 >>>  how can I actually find out more about an SQL error except by
 >>>looking at the message in an exception?
 >>>
 >>>  If I try to insert into a non-existing relation or an insert
 >>>generates a duplicate key, the thrown SQLException yields SQLstate
 >>>null and ErrorCode 0...  Just the result from
 >>>SQLException.getMessage() seems to make sense...
 >>>
 >>>
 >>>I am using postresql-7.2.1-2 from Debian "testing" on linux-i386.
 >>>The error occurs on both the current libpgjava package as well as
 >>>the latest beta driver (pg73b1jdbc3.jar) from jdbc.postgresql.org.
 >>>
 >>>
 >>>Is that behaviour 'normal' in the postgresql JDBC driver?
 >>>Or is there some problem with the setup on my side?
 >>>
 >>>
 >>>        Benedikt
 >>>
 >>>  BEAUTY, n.  The power by which a woman charms a lover and terrifies a
 >>>    husband.
 >>>            (Ambrose Bierce, The Devil's Dictionary)
 >>>
 >>>
 >>>---------------------------(end of broadcast)---------------------------
 >>>TIP 4: Don't 'kill -9' the postmaster
 >>>
 >>
 >>
 >>
 >>---------------------------(end of broadcast)---------------------------
 >>TIP 6: Have you searched our list archives?
 >>
 >>http://archives.postgresql.org
 >
 >