pg.ddx.io pgsql-novice@postgresql.org mailing list archivehelp / color / mirror / Atom feed
[NOVICE] Primary and Foreign Key? 1+ messages / 0 participants [nested] [flat]
* [NOVICE] Primary and Foreign Key? @ 1970-01-01 00:00 0 siblings, 0 replies; 1+ messages in thread From: @ 1970-01-01 00:00 UTC (permalink / raw) To: pgsql-novice I have the following related tables: PEOPLE -------------- peopleid pkey, name, etc GROUPS ------------- groupid pkey, description, etc PEOPLEGROUPS ------------------- peopleid pkey/fkey, groupid pkey/fkey What is the CORRECT way (in Postgres) to define the PEOPLEGROUPS table so that it has both the double primary key AND still acts as a foreign key for people.peopleid and groups.groupid? Can i specify both or is this not necessary? Any suggestions would be appreciated. Thanks! -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 9/22/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 9/22/2005 ^ permalink raw reply [nested|flat] 1+ messages in thread
only message in thread Thread overview: 1+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1970-01-01 00:00 [NOVICE] Primary and Foreign Key?
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox