Re: Changing the Primary Key Column

>>>>> "Rich" == Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:

Rich> Joe Celko doesn't like synthetic keys, either.

What does Joe Celko think about the "washington's axe" problem?

For those not familiar:

The museum guide tells the visitor that "yes, this is the original axe
that Washington used to chop down the cherry tree". The visitor
replies "Really?", to which the guide says "well, the handle has been
replaced three times, and the blade twice."

So, is that the same axe or not? If it is, then you need a synthetic
key. If not, then Celko is right.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.posterous.com/ for Smalltalk discussion