Re: sqlstate is HY000 for not_null_violation - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: sqlstate is HY000 for not_null_violation
Date
Msg-id 4A967561.6060702@tpf.co.jp
Whole thread Raw
In response to Re: sqlstate is HY000 for not_null_violation  (ning <mailxiening@gmail.com>)
List pgsql-odbc
ning wrote:
> Thank you Inoue-san,
>
> By setting in odbc.ini,
>   Protocol          = 7.4
> I got sqlstate=23502 from SQLGetDiagRec() as expected.
>
> Since I am using psqlodbc08.02.0400 with unixODBC connecting to
> PostgreSQL8.2.4, I think that setting Protocol=8.2.4 is also
> reasonable, but that is not true, I got "HY000" by setting to 8.2.4.
> I cannot find information about available protocol numbers, could you
> help to give a clue?

The protocol option means FE/BE protocol and must be
6.2, 6.3, 6.4 or 7.4 .

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Error in psqlodbc configuration
Next
From: "Andrus"
Date:
Subject: 08.04.0100: Couldn't load libpq library