Unique or Primary Key?
| От | pgsql@itsbruce.uklinux.net |
|---|---|
| Тема | Unique or Primary Key? |
| Дата | |
| Msg-id | 20010503005803.A12822@knossos.bruce обсуждение |
| Ответы |
Re: Unique or Primary Key?
|
| Список | pgsql-general |
This table is man-in-the-middle of a many-to-many relationship:
CREATE TABLE cv_entries (
subscriber INTEGER NOT NULL
REFERENCES subscribers
ON DELETE CASCADE
ON UPDATE CASCADE,
entry_type INTEGER NOT NULL
REFERENCES cv_entry_types
ON DELETE CASCADE
ON UPDATE CASCADE,
ordinal INTEGER,
value1 TEXT,
value2 TEXT,
minimum_trust SMALLINT,
UNIQUE(subscriber, entry_type, ordinal)
);
I used a unique index here because I couldn't see any reason for a
Primary Key - this table will always be searched on either the
subscriber or entry_type index.
Was I wrong? Should this be a Primary Key?
--
Bruce
Bitterly it mathinketh me, that I spent mine wholle lyf in the lists
against the ignorant.
-- Roger Bacon, "Doctor Mirabilis"
В списке pgsql-general по дате отправления: