steps to ensure referential integrity

Поиск
Список
Период
Сортировка
От Jodi Kanter
Тема steps to ensure referential integrity
Дата
Msg-id 3F6F18F7.4000400@virginia.edu
обсуждение исходный текст
Ответы Re: steps to ensure referential integrity
Список 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@virginia.edu


 

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Cornelia Boenigk"
Дата:
Сообщение: Re: [GENERAL] Warning: PostgreSQL query failed
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: error with functions