From: | Jerome Alet <alet(at)librelogiciel(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | not sure about constraints |
Date: | 2005-09-02 13:23:56 |
Message-ID: | 20050902132356.GD10284@mail.librelogiciel.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I've got 4 tables :
CREATE TABLE tableA (id SERIAL PRIMARY KEY NOT NULL,
blahA TEXT);
CREATE TABLE tableB (id SERIAL PRIMARY KEY NOT NULL,
blahB TEXT);
CREATE TABLE tableC (id SERIAL PRIMARY KEY NOT NULL,
ida INT4 REFERENCES tableA(id),
idb INT4 REFERENCES tableB(id),
blahC TEXT);
CREATE TABLE tableD
(id SERIAL PRIMARY KEY NOT NULL,
ida INT4,
idb INT4,
blahC TEXT,
CONSTRAINT checkAB FOREIGN KEY (ida, idb) REFERENCES tableC(ida, idb));
Is the definition of tableD sufficient, or should I do it this way
instead :
CREATE TABLE tableD
(id SERIAL PRIMARY KEY NOT NULL,
ida INT4 REFERENCES tableA(id),
idb INT4 REFERENCES tableB(id),
blahD TEXT,
CONSTRAINT checkAB FOREIGN KEY (ida, idb) REFERENCES tableC(ida, idb));
which looks superfluous to me.
???
Thanks in advance
Jerome Alet
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleus Mantzios | 2005-09-02 13:43:15 | Re: not sure about constraints |
Previous Message | Michael Fuhr | 2005-09-02 13:12:11 | Re: cursor "<unnamed portal 1>" already in use |