Re: [GENERAL] FW: Surrogate keys (Was: enums)

2006-01-19 Thread Thomas Hallgren
Josh Berkus wrote: Why? I don't find this statement to be self-evident. Why would we have ON UPDATE CASCADE if keys didn't change sometimes? Many times you will have references to a specific row from somewhere outside of your database. Perhaps you have a federation of web services that col

Re: [GENERAL] FW: Surrogate keys (Was: enums)

2006-01-19 Thread Josh Berkus
Thomas, Many times you will have references to a specific row from somewhere outside of your database. Perhaps you have a federation of web services that collaborate or other arbitrary URL's that contain the key. It might be harder to create remote row sets, middle tier caches, and other sim