foreign keys - script
От | Adam Lang |
---|---|
Тема | foreign keys - script |
Дата | |
Msg-id | 012101c011dc$418b4f20$330a0a0a@Adam обсуждение исходный текст |
Ответы |
Re: foreign keys - script
Re: foreign keys - script Re: foreign keys - script |
Список | pgsql-general |
I'm also having a problem with my references. In the script below, I get this error after each references statement: NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented Any ideas? drop table model_part; drop table models; drop table parts; drop table category; drop sequence model_part_model_part_id_seq; create table category ( category_id char(5) primary key, name varchar(20)); create table parts ( part_id char(10) primary key, category_id char(5) references category on delete cascade, name varchar(20), price numeric(7,2)); create table models ( model_id char(10) primary key, name varchar(20), description text); create table model_part ( model_part_id serial, part_id char(10) references parts on delete cascade, model_id char(10) references models on delete cascade); Adam Lang Systems Engineer Rutgers Casualty Insurance Company
В списке pgsql-general по дате отправления: