Re: Surrogate Key vs Production Key

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 8 Oct 2004 20:04:33 -0700
Message-ID: <73e20c6c.0410081904.635ceb51@posting.google.com>

ed.prochak_at_magicinterface.com (Ed prochak) wrote in message news:<4b5394b2.0410081003.1a57317f_at_posting.google.com>...
>
> really? Zero problems?
>
> just wait until you get ONE bug into the production system with
> surrogate keys and all hell break loose. Or a conversion from such a
> system where the dump program has a bug.

I don't understand. Are you suggesting that surrogate keys are buggy or that only surrogate key systems have bugs? Because if you are either of them, then let's talk bridges indeed.

> All a surrogate key does is convert a relational model database into a
> network model database.

That is an impossibility.

> I've done it both ways. Both work, but both also have their problems.

Still waiting to hear of one with SKs. Received on Fri Oct 08 2004 - 22:04:33 CDT