Adding Foreign Key Constraint To Existing Table

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Adding Foreign Key Constraint To Existing Table
Дата
Msg-id alpine.LNX.2.00.1107011357390.31349@salmo.appl-ecosys.com
обсуждение исходный текст
Ответы Re: Adding Foreign Key Constraint To Existing Table  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Adding Foreign Key Constraint To Existing Table  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Adding Foreign Key Constraint To Existing Table  (Thom Brown <thom@linux.com>)
Re: Adding Foreign Key Constraint To Existing Table  (Thom Brown <thom@linux.com>)
Re: Adding Foreign Key Constraint To Existing Table  (David Johnston <polobo@yahoo.com>)
Список pgsql-general
   I've examined the 9.0 manual page on alter table without seeing how to add
a foreign key constraint to a column.

   I needed to make changes on a couple of existing tables which could be
accomplished only by dropping the foreign key constraint. That, and changing
the table structure, column names, and column types were successful. But, I
am not seeing the proper syntax to add a foreign key constraint back to the
two affected tables.

   Pointer please.

Rich


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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pg_upgrade does not translate tablespace location to new cluster
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Adding Foreign Key Constraint To Existing Table