Referential Integrity --> SystemTables

From: "David M(dot) Richter" <d(dot)Richter(at)dkfz-heidelberg(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Referential Integrity --> SystemTables
Date: 2001-09-03 12:54:24
Message-ID: 3B937D80.80D71D5F@dkfz-heidelberg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I want to update a old postgresdatabase. In the time of databasecreation
the postgres had no "references" construct. So the integrity is
maintained by the C-Driver.
Now I want to build in the integrity. But i have to maintain
compatibiliy to old databases in the code itself.
So my question:
HOW can I determine if the database has referential integrity used or
not? Are there in the database any "references" in use or not?
Maybe it is descripted in any systemtable(pg_xyz)?

Thanks in advance

David

Attachment Content-Type Size
d.Richter.vcf text/x-vcard 498 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tankgirl 2001-09-03 13:33:07 Adding a Foreign key!
Previous Message Norbert Zoltan Toth 2001-09-03 09:01:48 query not using index