Postgres Pro
Downloads
Home   >   mailing lists

Re: UUID column as pimrary key? - Mailing list pgsql-general

From Scott Ribe
Subject Re: UUID column as pimrary key?
Date
Msg-id ED5F8B5E-969D-427C-80A0-FD7ED7598E93@elevated-dev.com
Whole thread Raw
In response to Re: UUID column as pimrary key?  (Mike Christensen <mike@kitchenpc.com>)
List pgsql-general
Tree view 
On Jan 5, 2011, at 8:03 AM, Mike Christensen wrote:

> As long as all your UUIDs are generated with the same algorithm, they
> are guaranteed to be unique.

There is no requirement that they be generated with the same algorithm in order to be unique. A MAC/time-based UUID
cannotduplicate a random one, and vice versa. (Also applies to the 3rd flavor of UUID whose details I do not remember.) 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: UUID column as pimrary key?
Next
From: Scott Ribe
Date:
Subject: Re: UUID column as pimrary key?