Received: from marte.Deuroconsult.ro (0@E-NS2.Deuroconsult.ro
	[193.226.167.164]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA38873
	for <pgsql-interfaces@postgresql.org>;
	Tue, 16 May 2000 20:45:30 -0400 (EDT) (envelope-from raul@brahms.ro)
Received: from brahms.ro (C229.Deuroconsult.ro [195.179.253.229])
	by marte.Deuroconsult.ro (8.10.1/8.10.1) with ESMTP id e4H0jKV22178
	for <pgsql-interfaces@postgresql.org>; Wed, 17 May 2000 03:45:20 +0300
Message-ID: <3921EC71.C51C3AAF@brahms.ro>
Date: Wed, 17 May 2000 03:48:49 +0300
From: Raul Chirea <raul@brahms.ro>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.5-15 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Some errors are not reported thru ODBC driver.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200005/11


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.