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
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? |