FK question
| От | Igor Kryltsov |
|---|---|
| Тема | FK question |
| Дата | |
| Msg-id | cgk124$mds$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: FK question
|
| Список | pgsql-general |
Hi,
What is a difference, if any, between:
_________________________________
ALTER TABLE ONLY employee_role
ADD CONSTRAINT fk_survey_id_employee_id FOREIGN KEY (survey_id,
employee_id) REFERENCES employee_survey(survey_id, employee_id) MATCH FULL
ON UPDATE C
ASCADE ON DELETE CASCADE;
__________________________________
AND
___________________________________
ALTER TABLE ONLY employee_role
ADD CONSTRAINT fk_survey_id FOREIGN KEY (survey_id) REFERENCES
employee_survey(survey_id) MATCH FULL ON UPDATE C
ASCADE ON DELETE CASCADE;
ALTER TABLE ONLY employee_role
ADD CONSTRAINT fk_employee_id FOREIGN KEY (employee_id) REFERENCES
employee_survey(employee_id) MATCH FULL ON UPDATE C
ASCADE ON DELETE CASCADE;
_____________________________________
Thank you,
Igor
В списке pgsql-general по дате отправления: