On Wed, May 20, 2015 at 11:52:08PM +0000, Peter Aronson wrote: > Now you're just getting silly. ?What if the application sets all rowids, > everywhere to 1? ?The fact is, the chance of collision on a UUID is pretty > astronomically low as long as a decent source of entropy is used > (see?http://en.wikipedia.org/wiki/Universally_unique_identifier#Random_UUID_probability_of_duplicates). > ?Yes, some application might not generate proper UUIDs, but that's true > with any scheme that needs to coordinate disconnected data editing or > generation on multiple machines.
Moreover, there are widespread examples of colliding UUIDs, say EBD0A0A2-B9E5-4433-87C0-68B6B72699C7. This means that this idea have already proven to fail on it's intended usage. > ?There are lots of applications out there that use UUIDs pretty successfully. Much less than a number of applications which use integers ;-) Val. Dav.