From: Erny <aerd@retemail.es>
To: pgsql-interfaces@postgresql.org
Subject: Driver or Postgres doesn't report refer. integr. errors
Date: Thu, 5 Oct 2000 19:18:21 +0200
Message-ID: <00cf01c02ef0$4fb0cef0$0d00dcc0@celeron> (raw)
Hi,
I'm running 7.0 on NT (with cygwin) and ODBC 6.50
I picked up the pgupt.mdb (0.15) to upsize from Access 97.
I changed it to use ON UPDATE, ON DELETE ... in the Create statements, discarding all the other trigger creations. I'm still early in development, so I still have not many ideas on the interaction with the drivers.
The good news is that all my database with a lot of tables just convert correctly to 7.0 (including the whole referential integrity) and default values. Perhaps I will publish soon all the modifications I did on pgupt.mdb
After that, I linked all the tables in Access 97 (fast and easy).
The bad news, whenever I delete or update a record causing error in referential integrity, no error is reported to Access. The record seems to disappear, but when rereading the table (or recordset), the 'deleted' record reappears.
(please send cc to me: aerd@mx3.redestb.es )
Thanx in advance,
Erny
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: aerd@retemail.es
Subject: Re: Driver or Postgres doesn't report refer. integr. errors
In-Reply-To: <00cf01c02ef0$4fb0cef0$0d00dcc0@celeron>
* 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