Foreign key references to non-primary key columns

Поиск
Список
Период
Сортировка
От Camm Maguire
Тема Foreign key references to non-primary key columns
Дата
Msg-id 54zoia37zd.fsf@intech19.enhanced.com
обсуждение исходный текст
Ответы Re: Foreign key references to non-primary key columns  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Greetings!  I've noticed in the documentation that the sql standard
requires foreign keys to reference primary key/(or maybe just unique)
columns, but that postgresql does not enforce this.  Is this a feature
that is intended to persist, or a temporary deviation from the sql
standard?  The current postgresql behavior seems useful in cases where
one wants to update a foreign key to a value already in the original
table.  

Take care,
-- 
Camm Maguire                             camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah


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

Предыдущее
От: Camm Maguire
Дата:
Сообщение: copy from stdin limits
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: Need help with phys backed shm segments (Postgresql+FreeBSD).