Re: guid/uuid datatype - Mailing list pgsql-patches

From Neil Conway
Subject Re: guid/uuid datatype
Date
Msg-id 1169310635.27197.55.camel@localhost.localdomain
Whole thread Raw
In response to Re: guid/uuid datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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.

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



pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Tablespace for temporary
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] psql \lo_* quiet mode patch