Re: Error Codes in 7.4

Hi Gabor,

I'm afraid the answer is, most likely, no.

The ODBC driver works with version 2 of the client-server protocol. This
version does not have error codes support.

Shachar

SZ?CS Gabor wrote:

>Dear Gurus,
>
>As of v7.4, PostgreSQL supports error codes. I'd like to know if we may hope
>for a version of psqlODBC that handles error codes.
>
>I tried with PostgreSQL 7.4.1, ODBCExpress 6.0 (dated 2003 Oct) and psqlodbc
>7.3.1.0 (dated 2003 May 15) and got the following (I assume useless) answer.
>
>Also tried psqlodbc 7.3.2.4 (dated 2003 Nov 12) and the SQLGetDiagRec
>function, with the same result.
>
> Message = "ERROR: update or delete on \"cikk\" violates foreign key
>constraint \"$1\" on \"szallitolevel_tetele\""
> Native = 7
> SQLState = "HY000"
>
>AFAIK these error codes say something like "general error" in ODBC terms :)
>This so-called state, "HY000" is not even an SQL state, unless I'm fatally
>mistaken. It's some kind of ODBC state, isn't it?
>
>Awaiting your kind response,
>
>G.
>
>

--
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/