Re: Fixing SQLException error codes.

Barry Lind wrote:

> No, the backend does not have proper error codes. See the TODO list
> item "Allow elog() to return error codes, module name, file name, line
> number, not just messages (Peter E) [elog]"
> (http://www.postgresql.org/docs/todo.html)
>
> It doesn't make sense to do this in JDBC until the server first supports
> error codes. If you want to contribute, it would be best to help
> getting this into the core server so that all interfaces, not just JDBC
> can take advantage of it.
>
> thanks,
> --Barry
>
> PS. I agree this would be nice to have in core as well as JDBC.
>
>
> Martin Algesten wrote:
>
>> Well yeah... that is the question.. Does the backend have standardised
>> error
>> codes... I hoped someone could point me in the right direction before
>> I do
>> anything that isn't useful in the long run.
>>
>> M
>>
>> On 24/6/01 11:16, "Joe Shevland" <J(dot)Shevland(at)eclipsegroup(dot)com(dot)au> wrote:
>>
>>
>>> This would be a very handy feature, Oracle's JDBC implementation does
>>> this
>>> and it makes it nice and easy to produce descriptive error messages
>>> for the
>>> end user (among other things).
>>>
>>> I'm wondering if there are standard error codes returned by the
>>> backend or
>>> whether you need to create new ones. I can't see there being any problem
>>> with it though. I've got a few links to the Oracle JDBC error codes
>>> if you
>>> want a reference.
>>>
>>> Regards,
>>> Joe
>>>
>>>
>>>> -----Original Message-----
>>>> From: Martin Algesten [mailto:martin(at)taglab(dot)com]
>>>> Sent: Sunday, 24 June 2001 7:41 PM
>>>> To: pgsql-jdbc(at)postgresql(dot)org
>>>> Subject: [JDBC] Fixing SQLException error codes.
>>>>
>>>>
>>>> Hi all!
>>>>
>>>> I would like to have the problem with the getErrorCode in SQLException
>>>> always returning 0 fixed. So I figured, why don't do it
>>>> myself? ... Just tot
>>>> check before I start looking at it...
>>>>
>>>> Has there been any attempt fixing it? Are someone doing it
>>>> anyway? Are there
>>>> any known problems with doing it?
>>>>
>>>> Cheers,
>>>> Martin
>>>>
>>>>
>>>> ---------------------------(end of
>>>> broadcast)---------------------------
>>>> TIP 1: subscribe and unsubscribe commands go to
>>>> majordomo(at)postgresql(dot)org
>>>>
>>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 2: you can get off all lists at once with the unregister command
>>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>>
>>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>>
>
>