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