Re: Error Codes in 7.4

From: Shachar Shemesh <psql(at)shemesh(dot)biz>
To: SZ?CS Gabor <surrano(at)mailbox(dot)hu>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error Codes in 7.4
Date: 2004-03-29 16:00:51
Message-ID: 40684833.9060806@shemesh.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2004-03-30 12:41:51 MS Access Linked Table
Previous Message SZ?CS Gabor 2004-03-29 12:49:18 Error Codes in 7.4 (was: Re: error 23000 is not treated in psqlODBC)