| From: | pgsql(at)itsbruce(dot)uklinux(dot)net |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Unique or Primary Key? |
| Date: | 2001-05-02 23:58:03 |
| Message-ID: | 20010503005803.A12822@knossos.bruce |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2001-05-03 00:29:46 | Re: Ideal hardware configuration for pgsql |
| Previous Message | GH | 2001-05-02 23:52:30 | Re: Ideal hardware configuration for pgsql |