Re: GUID/UUID Support

Поиск
Список
Период
Сортировка
От Chad Wagner
Тема Re: GUID/UUID Support
Дата
Msg-id 81961ff50701161835g712353ddsa210401b9446969b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GUID/UUID Support  (David Lee Lambert <as4109@wayne.edu>)
Ответы Re: GUID/UUID Support  ("Patrick Earl" <patearl@patearl.net>)
Список pgsql-general
On 1/16/07, David Lee Lambert <as4109@wayne.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/

В списке pgsql-general по дате отправления:

Предыдущее
От: "Abdul Hayee Bhatti"
Дата:
Сообщение: Re: Process won't start in Windows
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)