From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
---|---|
To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | steps to ensure referential integrity |
Date: | 2003-09-22 15:44:55 |
Message-ID: | 3F6F18F7.4000400@virginia.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have inherited a database that was originally created in postgres
version 6.? There were no steps taken at that time to implement
constraints to ensure referential integrity. There are no FK
constraints, PK constraints, etc..
Most of what currently exists is done in the existing code. I would like
to change this and am interested in getting suggestions. I expect that
PK constraints on each table as well as all FK constraints should be in
place. Anything else that I should consider?
I have indexes currently set up on a variety of fields, including PK
fields. Do the constraints automatically generate indexes on these
fields such that I should remove the ones created at the end of my script?
Thanks in advance for the suggestions!
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>
From | Date | Subject | |
---|---|---|---|
Next Message | Hornyak Laszlo | 2003-09-22 16:07:01 | postgres 6.2 vacuum |
Previous Message | Stephan Szabo | 2003-09-22 15:43:38 | Re: error with functions |