From: | "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com> |
---|---|
To: | "David Lee Lambert" <as4109(at)wayne(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: GUID/UUID Support |
Date: | 2007-01-17 02:35:05 |
Message-ID: | 81961ff50701161835g712353ddsa210401b9446969b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/16/07, David Lee Lambert <as4109(at)wayne(dot)edu> wrote:
>
> The problem with a random UUID generator is: where do you get the random
> numbers? However, there are really only two platforms to worry about:
> POSIX (use libuuid) and Win32 (there is probably a Win32 function to
> generate
> it, since MS SQL Server and the .NET API both provide GUID
> generation; but
> I can't seem to find it by searching the Web).
>
> Anyway, the uniqueidentifier project on GBorg seems like it has what you
> want: a user-defined type, and a generator. I think the main thing it
> needs is some code cleanup/robustness and a lot of production testing.
>
FYI...
Apache Portable Runtime has a uuid generator, see apr-util package, function
is apr_uuid_get(). Underlying it uses one of the following:
a) uuid_create (FreeBSD via libc)
b) uuid_generate (from libuuid)
c) UuidCreate (for Win32)
d) Apache version of a UUID generator
From | Date | Subject | |
---|---|---|---|
Next Message | Vinesh, Raghavan | 2007-01-17 03:50:15 | Installation of PostgreSQL Service under admin account |
Previous Message | Abdul Hayee Bhatti | 2007-01-17 02:14:20 | Re: Process won't start in Windows |