Here is an example:
CREATE TABLE membershipextras
(
MemberID int4 NOT NULL DEFAULT 0,
Type char(1) NOT NULL DEFAULT '1',
GenericField char(1),
GenericOneToOne2 int4,
GenericOneToOne3 int4,
GenericText2 varchar(32),
GenericText3 varchar(32),
PaidThrough datetime,
Note text,
PRIMARY KEY (MemberID, Type),
CONSTRAINT MembershipExtrasMemberID_fk FOREIGN KEY (MemberID) REFERENCES Membership(MemberID) ON DELETE CASCADE
);
-----Original Message-----
From: Christian Anton [SMTP:christiananton@hotmail.com]
Sent: Monday, April 30, 2001 10:10 PM
To: pgsql-admin@postgresql.org
Subject: URGENT HELP NEEDED
Hello,
I'm a college student in a db development course. I use postgres 7.03 on
RedHat 7.1, I need help setting foreign key constraints and I cannot find in
the doc's and I cannot access postgres.org. I have a db due literally
yesterday, if I can't get it in tomorrow I lose my hard earned 'A'.
HELP! PLEASE!
I'm alomost sure I've done this before on Psql by simply stating
"CONSTRAINT YADDA_FK FOREIGN KEY (SHMACKITY) REFERENCES SHMACK(SMACKITY)"
Foreign key support is supposed to be in now right???
Please, cannot stress how important this is to me enough.
C. Anton
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly