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: | Raw Message | Whole Thread | 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 |