Thread: [ psqlodbc-Bugs-1000495 ] duplicate key causes HY000 SQL-State
Bugs item #1000495, was opened at 2005-12-21 07:27 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000495&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Tom Zschockelt (toz) Assigned to: Nobody (None) Summary: duplicate key causes HY000 SQL-State Initial Comment: while inserting a row into an table with primary key the current snapshot ( 8.01.01.05 ) returns a wrong sqlstate HY000 instead of the 8.01.01.02 driver which returns a 23005 sqlstate (which is correct) e.g. create table test1 ( field1 int2 primary key, field2 varchar(10) null ); insert into test1 (field1, field2) values ( 1, 'test'); insert into test1 (field1, field2) values ( 1, 'another test'); AFAIK the second insert should return with SQL_ERROR and sqlstate 23000 or 23005. ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000495&group_id=1000125