On Mon, Sep 29, 2008 at 11:05 PM, Steve Midgley <science@misuse.org> wrote:
> Any reason why using serial PK's with "compound
> natural unique indices" is better/worse than just using natural PK's?
Not really, surrogate keys will always work well so long as unwanted
duplicates are constrained. Surrogate Keys will allow as much
flexibility and versatility as is possible. However as the case of
unwanted duplicates illustrates, sometimes flexibility and versatility
is always wanted. So if flexibility and versatility is valued less
than the ability to add inflexible constraints (beyond preventing
duplicates) across multiple relationships, then using natural primary
keys becomes very attractive.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug