Skip site navigation (1) Skip section navigation (2)

Re: SQLGetDiagRec, sqlstate returned?

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Zubkovsky, SergeyDate: 2008-02-12 12:32:36
Subject: timestamp as varchar(23)
Previous:From: Heiser, DorisDate: 2008-02-08 16:02:52
Subject: SQLGetDiagRec, sqlstate returned?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group