Re: GUID/UUID Support

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

--
Chad
http://www.postgresqlforums.com/

In response to

Responses

Browse pgsql-general by date

  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