Re: SQLGetDiagRec, sqlstate returned?

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

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