Re: Avoiding surrogate keys

2010/5/4 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
>
> Another thing, If your PK changes, it is no longer a PK, you can't rely on it.

Depending upon what you mean by changes this could be true or it could
be a matter of opinion.  If your referring to a candidate key's value
changes, this key still provides a useful way to identify a tuple.

Also, just because a surrogate key is a useful way to identify a row,
by itself it does nothing to uniquely identify an entity that a row
represents.  On some DBMS forums that I frequent, it is a daily
occurrence to see questions on how to eliminate duplicate rows.  So,
for some people, there are times when even surrogate keys cannot be
relied upon as a PK.
--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug