sqlstate is HY000 for not_null_violation

From: ning <mailxiening(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: sqlstate is HY000 for not_null_violation
Date: 2009-08-20 07:47:01
Message-ID: 27f31620908200047w2698c18aof7e72eddfdd5722b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

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
http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html

Any idea to get 23502 instead of HY000?

Greeatings,
ning

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adnan DURSUN 2009-08-20 11:15:41 ODBC driver & connection limit
Previous Message Assaf Lavie 2009-08-19 16:38:02 Re: ODBC 64-bit driver request