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

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

pgsql-odbc by date

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

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