Skip site navigation (1) Skip section navigation (2)

RE: URGENT HELP NEEDED

From: Michael Davis <mdavis(at)sevainc(dot)com>
To: "'Christian Anton'" <christiananton(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: RE: URGENT HELP NEEDED
Date: 2001-05-04 23:55:55
Message-ID: 01C0D4C3.7CCE73F0.mdavis@sevainc.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)hotmail(dot)com]
Sent:	Monday, April 30, 2001 10:10 PM
To:	pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly


pgsql-admin by date

Next:From: John PagakisDate: 2001-05-04 23:56:40
Subject: RE: Queries
Previous:From: Bruce MomjianDate: 2001-05-04 22:08:34
Subject: Re: Re: Use of the LIMIT clause ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group