Some errors are not reported thru ODBC driver.

Hi there,

I observed that some errors are not reported by the ODBC driver (Win9x).

My case was:

create table master (id integer not null, primary key (id));
create table detail (id, master_id, primary key (id), foreign key
(master_id) references master (id));

insert into master values (1);
insert into detail values (1, 1);

Now, if you try this (using ODBC):

delete from master where id = 1;

the ODBC driver reports success, but it is obvious that this is not
possible. More than that
in "psql" you will obtain:

ERROR:  <unnamed> referential integrity violation - key in master still
referenced from detail


Bye.