foreign keys - script - Mailing list pgsql-general

From Adam Lang
Subject foreign keys - script
Date
Msg-id 012101c011dc$418b4f20$330a0a0a@Adam
Whole thread Raw
Responses Re: foreign keys - script
Re: foreign keys - script
Re: foreign keys - script
List 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 by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: SQL scripts - sequences
Next
From: Stephan Szabo
Date:
Subject: Re: foreign keys - script