How to implement referential facilities in PostgreSQL

From: leif(at)danmos(dot)dk
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: How to implement referential facilities in PostgreSQL
Date: 1999-01-04 14:24:00
Message-ID: m0zxADW-000G4UC@danmos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-01-04 16:30:11 Re: [INTERFACES] pgaccess troubles on HP-UX
Previous Message Constantin Teodorescu 1999-01-04 07:59:38 Re: [INTERFACES] pgaccess troubles on HP-UX