Re: sqlstate is HY000 for not_null_violation

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: ning <mailxiening(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: sqlstate is HY000 for not_null_violation
Date: 2009-08-27 12:00:33
Message-ID: 4A967561.6060702@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus 2009-09-03 10:59:21 08.04.0100: Couldn't load libpq library
Previous Message Hiroshi Inoue 2009-08-27 11:39:22 Re: Error in psqlodbc configuration