From: | Ferindo Middleton Jr <fmiddleton(at)verizon(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | redundancy in CHECK CONSTRAINTs |
Date: | 2005-09-25 03:34:15 |
Message-ID: | 43361AB7.2020701@verizon.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I have the following table:
CREATE TABLE gyuktnine (
id SERIAL,
intsystem INTEGER NOT NULL REFERENCES yuksystems(id) CONSTRAINT
int_cannot_equal_ext
CHECK (intsystem != extsystem),
extsystem INTEGER NOT NULL REFERENCES yuksystems(id) CONSTRAINT
ext_cannot_equal_int
CHECK (extsystem != intsystem),
PRIMARY KEY (intsystem, extsystem)
);
the intsystem and extsystem fields both have a check constraint on them
which preventing any one record from having values in which they are
equal. There is also a primary key. Is this redundant? Do only one of
them really need this constraint? Or does it not really matter. I'm
concerned about using constraints like this and have redundant checks
built in slowing down my db.
Ferindo
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-25 03:58:21 | Re: redundancy in CHECK CONSTRAINTs |
Previous Message | Chris Browne | 2005-09-24 21:27:19 | Re: stored procs in postgresql |