Received: from toutatis.comune.modena.it (monet.comune.modena.it [195.223.135.239]) by hub.org (8.10.1/8.10.1) with SMTP id e6I6uD061993 for ; Tue, 18 Jul 2000 02:56:14 -0400 (EDT) Received: from stargate.comune.modena.it (comnet.comune.modena.it [192.168.5.129]) by toutatis.comune.modena.it (8.9.1a/8.9.1) with ESMTP id IAA10282 for ; Tue, 18 Jul 2000 08:56:12 +0200 (MET DST) Received: from mail2.comnet.comune.modena.it (galatea.comnet.comune.modena.it [10.9.1.250]) by stargate.comune.modena.it (8.9.3/8.9.3) with ESMTP id JAA16121 for ; Tue, 18 Jul 2000 09:14:04 +0200 Received: from comune.modena.it ([10.7.8.254]) by mail2.comnet.comune.modena.it (Netscape Messaging Server 3.6) with ESMTP id AAA8C60 for ; Tue, 18 Jul 2000 08:49:02 +0200 Message-ID: <3973FF81.58ECE7B0@comune.modena.it> Date: Tue, 18 Jul 2000 08:56:01 +0200 From: "Andrea Aime" Reply-To: andrea.aime@comune.modena.it X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces Subject: [Fwd: ODBC driver and foreign keys] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/117 Hi (again?) I've sent the following message yesterday but I doesn't seems to have been posted on the mailing list. Now that I'm subscribed I hope you will see it ;-) Bye Andrea -------------------------------------------------------- Hi all people, I have found a bug in ODBC driver that makes me mad... if you violate a foreign key, ODBC driver won't tell you, claiming that the transaction performed ok... since foreign key are implemented as triggers, does this mean that any trigger violation won't be reported? Is there anyone who can fix that? (Luckily my app prevents fk violantions, but yesterday a bug made it violate a fk and I passed hours wondering why my transaction didn't update my database... ;-( ) Bye Andrea