From: | Justin Seiferth <seiferth(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | VARCHAR references |
Date: | 2001-05-03 21:53:35 |
Message-ID: | 20010503215335.99807.qmail@web13503.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have a problem with the insert form for table
eq_list. PostdgeQSL enforces the constraint on v_id
and will not allow record to be inserted unless the
the v_id exist in the vendor table
However for reason I do not understand PostgreSQL is
not enforcing the constraint that the proj_id exist
in the project table ????
I tried to check the table design but could not find a
command in psql that detail foreign keys or other
constraints. How can I display table constraints????
I created the table with the following file
CREATE TABLE eq_list (
eq_id VARCHAR(10) PRIMARY KEY,
description VARCHAR(128),
v_id INT4 REFERENCES vendor,
rate NUMERIC(8,2),
proj_id VARCHAR(10) REFERENCES project,
in_service BOOL DEFAULT 't'
);
Thanks,
Justin
=====
My web page is at: http://www.seiferth-ryan.com
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Schoenster | 2001-05-04 00:50:28 | Re: input from a file |
Previous Message | Eric Naujock | 2001-05-03 19:17:20 | Re: input from a file |