Re: Multiple keys?

Поиск
Список
Период
Сортировка
От Richard Poole
Тема Re: Multiple keys?
Дата
Msg-id 20020828102247.GA23727@guests.deus.net
обсуждение исходный текст
Ответ на Multiple keys?  (Casey Allen Shobe <cshobe@secureworks.net>)
Ответы Re: Multiple keys?  (Casey Allen Shobe <cshobe@secureworks.net>)
Список pgsql-admin
On Wed, Aug 28, 2002 at 02:10:44AM -0400, Casey Allen Shobe wrote:
> In order to get the foreign key I want working, I had to have two unique
> references on the parent table, though the second covers two columns that are
> contained within the first.  Is this wise?  Is there a better way?

Your two-column constraint, the one you need to add to get your foreign
key working, implies your three-column one. So you can just get rid of
the three-column one.

Richard

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

Предыдущее
От: Andre Schubert
Дата:
Сообщение: Errors with pg_dump
Следующее
От: Casey Allen Shobe
Дата:
Сообщение: Re: Multiple keys?