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(at)icemark(dot)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
>
>