On Fri, 2007-01-19 at 23:00 -0500, Tom Lane wrote:
> Per previous discussion, the main problem with a uuid type is the
> new-uuid generator function, which tends to involve a bunch of
> not-so-portable assumptions and code.

Advertising

RFC 4122 specifies several ways of generating UUIDs:
* via the computer's MAC address and the time since the Gregorian epoch
in nanoseconds
* via MD5 or SHA1 hashing of a given string of URL, or similar
identifier
* via a PSRNG
Only the first of these presents any portability concerns, AFAICS.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings