From: Raul Chirea <raul@brahms.ro>
To: pgsql-interfaces@postgresql.org
Subject: Some errors are not reported thru ODBC driver.
Date: Wed, 17 May 2000 03:48:49 +0300
Message-ID: <3921EC71.C51C3AAF@brahms.ro> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: raul@brahms.ro
Subject: Re: Some errors are not reported thru ODBC driver.
In-Reply-To: <3921EC71.C51C3AAF@brahms.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox