Get error message details - Mailing list pgsql-odbc

From Andrus
Subject Get error message details
Date
Msg-id dhru7p$tc7$1@news.hub.org
Whole thread Raw
List pgsql-odbc
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.



pgsql-odbc by date:

Previous
From: Håkon Clausen
Date:
Subject: Re: ODBC driver types
Next
From: "Chris Ingram"
Date:
Subject: Re: PATCH: Integrity constraint violation should set SQLSTATE to 23000