Re: [GENERAL] Sufficient Primary Key?

On Fri, 24 Jul 1998, Brett W. McCoy wrote:
> You can do multi-column keys in PostgreSQL, I believe, which is
> essentially what you would be doing by combining that data into a single
> column.

I don't like doing that because I don't want to store the entire
name in every other table which needs to be linked with this one.
So, for instance, in the table that keeps track of what authors go
to what book, I want it to just have two fields, the Book's primary
key and the Author's primary key, and I'd prefer those primary keys
to be nice and small instead of, say, the entire title and copyright
year for the book and the entire first and last name and date of
birth for the author. See what I mean?

> BTW, Alan Watts is a favourite of mine.

Mine too.

--Dan

-----------------------------------------------------------------------
Daniel G. Delaney The Louisville Times Chorus
Dionysos(at)Dionysia(dot)org www.LouisvilleTimes.org
www.Dionysia.org/~dionysos/ Dionysia Design
ICQ Number: 8171285 www.Dionysia.com/design/
-----------------------------------------------------------------------
I doubt, therefore I might be.