redundancy in CHECK CONSTRAINTs

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

Responses

Browse pgsql-sql by date

  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