In PgAdmin running code
create table t1 ( c1 serial primary key );
create table t2 ( c1 integer references t1);
insert into t1 values(1);
insert into t2 values (1);
delete from t1;
causes nice detailed error message
ERROR: update or delete on "t1" violates foreign key constraint
"t2_c1_fkey" on "t2"
DETAIL: Key (c1)=(1) is still referenced from table "t2".
Runnign this code through ODBC I got only ERROR: line
How to retrieve the DETAIL: line using ODBC ?
Andrus.