Re: [GENERAL] foreign keys - script

[Adam Lang]

But wouldn't the dependencies be there whether I compile from scratch or use
an RPM?

What the main issue that stumped was the libc.6.so dependency.  According to
epm -a -q, it is installed.

I guess I can blow out 6.5 and download the 7.0 source and reinstall a
compiled version.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Tom Lane" [EMAIL PROTECTED]
To: "Adam Lang" [EMAIL PROTECTED]
Cc: "Stephan Szabo" [EMAIL PROTECTED]; "PGSQL General"
[EMAIL PROTECTED]
Sent: Tuesday, August 29, 2000 6:47 PM
Subject: Re: [GENERAL] foreign keys - script


 "Adam Lang" [EMAIL PROTECTED] writes:
  As for using 7.02, I had tried installing it from scratch, but had
  dependency problems.  I attempted an "upgrade" just now, and here is the
  list of dependencies failures I had:

 Seems like grabbing the source distribution and doing "configure; make;
 make install" would be a lot easier ;-)

 regards, tom lane

Re: [GENERAL] foreign keys - script

[Tom Lane]

"Adam Lang" [EMAIL PROTECTED] writes:
 But wouldn't the dependencies be there whether I compile from scratch or use
 an RPM?

But if you compile from source, it will use whatever libc you have
installed.

regards, tom lane

[GENERAL] foreign keys - script

[Adam Lang]

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