VARCHAR references
От | Justin Seiferth |
---|---|
Тема | VARCHAR references |
Дата | |
Msg-id | 20010503215335.99807.qmail@web13503.mail.yahoo.com обсуждение исходный текст |
Список | 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/
В списке pgsql-novice по дате отправления: