Postgres Pro
Downloads
Home   >   mailing lists

When to use compound PK instead of a FK? - Mailing list pgsql-general

From Jamie
Subject When to use compound PK instead of a FK?
Date
Msg-id 1170604108.880422.22010@j27g2000cwj.googlegroups.com
Whole thread Raw
Responses Re: When to use compound PK instead of a FK?
List pgsql-general
Tree view 
I typically use compound primary keys when creating a table that
represents a many-to-many relationship. I was wondering if anyone else
had other situations in which you would use a compound PK? Why do you
use it instead of just a foreign key?

pgsql-general by date:

Previous
From: "finecur"
Date:
Subject: table updated status
Next
From: "Jim C."
Date:
Subject: Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year