Re: foreign keys - script

i created my foreign keys afterwards using a statement like this:

Alter table web_hits add constraint fk_webh_wu_id
foreign key (wu_id) references web_users(wu_id);

HTH
mikeo

At 01:12 PM 8/29/00 -0400, Adam Lang wrote:
>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
>