Message-ID: <001d01c058df$a847c140$6601a8c0@servidor>
From: "Ernesto Revilla" <aerd@retemail.es>
To: <pgsql-interfaces@postgresql.org>
Subject: Referential integrity rules
Date: Tue, 28 Nov 2000 03:05:15 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi all,

please, I do not have MS VisualC++ at hand, so I have no chance to recompile
the driver, but could anybody introduce a little code in order to indicate
the violation of integrity rules when executing insert, update or delete
statements?

As I understood, there's no way to pass error codes, thru ODBC, so the
return message has to be scanned. This should not be very difficult. I only
need some 'integrity rule violation' and if possible, some table names.

Why? I have a lot of work done with Microsoft Access, attacking Jet. But
it's getting small and Access is not very solid processing events. Also, it
is not client-server. I could migrate to other RDBMS, but it's expensive and
I want to migrate everything to open source, something like Python / Zope /
Postgres platform.

Please send mail to aerd@mx3.redestb.es

Thanx in advance,
Erny