foreign keys - script

Поиск
Список
Период
Сортировка
От Adam Lang
Тема foreign keys - script
Дата
Msg-id 012101c011dc$418b4f20$330a0a0a@Adam
обсуждение исходный текст
Ответы Re: foreign keys - script  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: foreign keys - script  (mikeo <mikeo@spectrumtelecorp.com>)
Re: foreign keys - script  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Adam Lang"
Дата:
Сообщение: Re: SQL scripts - sequences
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: foreign keys - script