More Database Design Stuff - Mailing list pgsql-sql

From Jimmie Fulton
Subject More Database Design Stuff
Date
Msg-id FB93404FB67ED311ABF9009027991188417F0B@www.ehso.emory.edu
Whole thread Raw
List pgsql-sql
This may seem like a newbie type of question:  for what reason would you
need a multi-column primary key.  None of the books that I have read explain
why or why not.  It seems that the more normalized your database is, the
less need for multi-column primary keys.  Are multi-column primary keys
considered bad form?  I have never needed to use them, but I happen to use
auto-incrementing integer primary keys on all tables, as discussed earlier
this week.  Any thoughts on this subject is appreciated.


Jimmie Fulton
Systems Administrator
Environmental Health & Safety Office
Emory University School Of Medicine



pgsql-sql by date:

Previous
From: Jason Earl
Date:
Subject: Re: Foreign key
Next
From: Jan Wieck
Date:
Subject: Re: Foreign key