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 ?
pgsql-odbc by date
|Next:||From: Chris Ingram||Date: 2005-10-03 22:04:17|
|Subject: Re: PATCH: Integrity constraint violation should set SQLSTATE to 23000|
|Previous:||From: Zlatko Matić||Date: 2005-10-02 23:14:57|
|Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL|