Re: Surrogate Key vs Production Key

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 9 Oct 2004 05:49:55 -0700
Message-ID: <73e20c6c.0410090449.48182296@posting.google.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41675d4e$0$10350$afc38c87_at_news.optusnet.com.au>...

>
> Count me in very firmly as a Natural Key man. But I respect your right to
> eat l'escargot, too.
>

Wait until you've had to design, code and get accepted by the users a few dozen systems. Then tell me if you still like natural keys. I used to like them too. Until I had to wear the consequences of incomplete relational models and incomplete implementations. Reality has this nasty way of catching up with the best theory... Received on Sat Oct 09 2004 - 07:49:55 CDT