From: leif@danmos.dk
To: pgsql-interfaces@postgreSQL.org
Subject: How to implement referential facilities in PostgreSQL
Date: Mon, 4 Jan 99 14:24 WST
Message-ID: <m0zxADW-000G4UC@danmos> (raw)
Hi everybody,
Happy New Year to you all.
We have a rather large M$ Access application for time and attendance
and job time registration. It has been implemented in M$ Access using a
M$ Access database running on a M$ 'operating system'.
One of our issues is to use the PostgreSQL in stead of/underneath the
M$ Access database application, which is the existing application running
well on M$ Access with not so large amounts of data. We of course need
to run this on a Linux box. The application makes extensive use of some
Access 'referential features'.
So my question is:
What is the equivalent of
'Enforce Referential Integrity',
'Cascade Update Related Fields', and
'Cascade Update Related Records' in
SQL/PostgreSQL terms. In other words, how do I get these facilities into
my PostgreSQL database? I need to be able to have the M$ Access application
to link directly to the PostgreSQL tables using ODBC, which I have managed
to copy directly using Access, but with no Primary/Foreign keys what so ever.
Thanks for any sugestions,
Leif
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: leif@danmos.dk
Subject: Re: How to implement referential facilities in PostgreSQL
In-Reply-To: <m0zxADW-000G4UC@danmos>
* 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