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.