From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Heiser, Doris" <Doris(dot)Heiser(at)fujitsu-siemens(dot)com> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: SQLGetDiagRec, sqlstate returned? |
Date: | 2008-02-08 17:24:32 |
Message-ID: | 47AC9050.20109@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Heiser, Doris wrote:
> Hi,
>
> I have some problems with sqlstates returned from SQLGetDiagRec with
> psqlodbc. We use PostgreSQL with psqlodbc on Linux systems.
>
> We do at least some checks on sqlstates returned from PostgreSQL within
> our application to implement some specific error reactions.
>
> This worked fine with psqlodbc 08.01.0200 and PostgreSQL 8.1.9. We used
> to get a specific sqlstate and error message, e.g. “22021”, “invalid
> byte sequence for encoding…”.
>
> Now we changed to psqlodbc 08.02.0500 and PostgreSQL 8.2.5. In the very
> same error situation we still see the error message as before. The
> sqlstate obtained with SQLGetDiagRec however seems to be always “HY000”
> (general error) in more or less any error situation.
I can see "22021" "invalid byte sequence ..." error message in a test
case.
Could you send me directly the Mylog message ?
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Zubkovsky, Sergey | 2008-02-12 12:32:36 | timestamp as varchar(23) |
Previous Message | Heiser, Doris | 2008-02-08 16:02:52 | SQLGetDiagRec, sqlstate returned? |