Driver or Postgres doesn't report refer. integr. errors

From: "Erny" <aerd(at)retemail(dot)es>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Driver or Postgres doesn't report refer. integr. errors
Date: 2000-10-05 17:18:21
Message-ID: 00cf01c02ef0$4fb0cef0$0d00dcc0@celeron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)mx3(dot)redestb(dot)es )
Thanx in advance,
Erny

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Gabriel Lopez 2000-10-06 11:51:26 Re: wrong documentation and others .....
Previous Message Clark, Joel 2000-10-05 13:23:03 RE: Re: FW: New PostgreSQL Project