Re: Add Foreign Keys To Table
От | John R Pierce |
---|---|
Тема | Re: Add Foreign Keys To Table |
Дата | |
Msg-id | 4E161498.1060303@hogranch.com обсуждение исходный текст |
Ответ на | Re: Add Foreign Keys To Table (Rich Shepard <rshepard@appl-ecosys.com>) |
Ответы |
Re: Add Foreign Keys To Table
|
Список | pgsql-general |
On 07/07/11 1:02 PM, Rich Shepard wrote: > On Thu, 7 Jul 2011, Alan Hodgson wrote: > >> create unique index index_name on table (column). > > Alan, > > This worked like a charm. > > Many thanks for the lesson, > > Rich > if your original table has Primary Key of (sta_type, secondary_type) I would not expect EITHER of those fields to be unique by themselves.... Surely there can be more than one of the same sta_type with different secondary_type's, just as there could be more than one secondary_type with different sta_types.... if either of these fields is unique of and by itself, it doesn't make sense to use the combined primary key. -- john r pierce N 37, W 122 santa cruz ca mid-left coast
В списке pgsql-general по дате отправления: