Foreign Key Unique Constraint can be dropped

Поиск
Список
Период
Сортировка
От Vlado Moravec
Тема Foreign Key Unique Constraint can be dropped
Дата
Msg-id dafe6b860906080348h76e26329vfcb21cb6a87798c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Foreign Key Unique Constraint can be dropped  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: Foreign Key Unique Constraint can be dropped  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,
from postgres docs: "foreign key must reference columns that either are a primary key or form a unique constraint". It does not allow creating foreign key constraint on non-unique column - an error is raised.
After playing with a new database I discovered that such a unique constraint can be droped after the foreign key constraint has been established. No warning, no error.
Is such a behaviour intended? I have found no references in the docs.
Thanks.
Vladimir

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Function: Change data while walking through records
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Schema, database, or tables in different folders?