foreign keys - script

From: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
To: "PGSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: foreign keys - script
Date: 2000-08-29 17:12:05
Message-ID: 012101c011dc$418b4f20$330a0a0a@Adam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Lang 2000-08-29 17:30:25 Re: SQL scripts - sequences
Previous Message Emile D Snyder 2000-08-29 17:03:48 replacement for LEFT JOIN in mysql->postres changeover?