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?
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq