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?
On Sun, Aug 23, 2009 at 6:26 PM, Hiroshi Inoue<inoue(at)tpf(dot)co(dot)jp> wrote:
> ning wrote:
>> I am using psqlodbc08.02.0400 with unixODBC connecting to PostgreSQL8.2.4.
>> For not_null_violation error, like
>> db=# create temp table ooid (oid_ integer not null);
>> CREATE TABLE
>> db=# insert into ooid values(NULL);
>> ERROR: null value in column "oid_" violates not-null constraint
>> The sqlstate returned by SQLGetDiagRec() is HY000, the message is
>> SQLSTATE=HY000;SQLCODE=7;ERROR: null value in column "oid_" violates
>> not-null constraint;Error while executing the query
>> which should be SQLSTATE=23502 according to
>> Any idea to get 23502 instead of HY000?
> Which protocol option are you setting ?
> You should set the 7.4+ protocol option.
> Hiroshi Inoue
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2009-08-27 11:39:22|
|Subject: Re: Error in psqlodbc configuration|
|Previous:||From: isharasjc||Date: 2009-08-26 09:34:30|
|Subject: Error in psqlodbc configuration|