referential integrity for insert
От
Ivan Horvath
Тема
referential integrity for insert
Дата
Msg-id
20020306094926.89268.qmail@web14704.mail.yahoo.com
Список
Дерево обсуждения
referential integrity for insert Ivan Horvath <pillesoft@yahoo.co.uk>
Re: referential integrity for insert "Josh Berkus" <josh@agliodbs.com>
i got two tables with the following structures: create table unit ( unit_id int4 not null primary key, unit_name varchar(10) not null) create table plant_unit ( pu_id int4 not null primary key, pu_code varchar(15), unit_id int4 not null references unit (unit_id) match all on delete restrict on update cascade) that means the two tables are connected to each other by the unit_id field. i cannot delete records from the unit table if there is a relation in the plant_unit table, and when i update the unit_id field in the unit table the system will update all matching records in the plant_unit table as well. my question is how can i avoid to insert record into the plant_unit table, when the specified unit_id is not available in the unit table. do i have to use trigger, or i miss something in the constraint, or whatelse? thanks Ivan __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/
В списке pgsql-novice по дате отправления
От: ghaverla@freenet.edmonton.ab.ca
Дата: