Re: Full GUID support

Поиск
Список
Период
Сортировка
От Patrick Earl
Тема Re: Full GUID support
Дата
Msg-id CAJOWoQ4omR8XgLbgJ0L17kNNvmgqbh-UGQ_EUHLnq6E7kwcBfQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Full GUID support  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
I'd have to agree on the importance of UUID support.  It's pretty much
essential for any sort of disconnected sync model.  We use UUIDs
(generated with the "guid.comb" technique) for our surrogate keys in
around 50 apps, and it has served us well.

We have also been seriously missing the 64-bit generator
functionality.  I've been watching the threads for half a year to see
when it will pop up again.  It's been a long wait.

Regarding UUID generation, IMHO, the random approach is the "standard"
at this point.  That'd be v4 in the oisp library.  It would be handy
to be able to generate these without having to load in special
extensions.  It's not the biggest deal though since we can run
initialization code to get the database set up... just more effort.
       Patrick Earl

On Mon, Jul 11, 2011 at 11:19 AM, Joshua D. Drake <jd@commandprompt.com> wrote:
> Uh.... UUID/GUID is used pervasively throughout enterprise apps, especially
> Java apps.


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

Предыдущее
От: Gurjeet Singh
Дата:
Сообщение: Re: Launching debugger on self on SIGSEGV
Следующее
От: Florian Pflug
Дата:
Сообщение: Re: Select For Update and Left Outer Join