Re: Full GUID support

From: Patrick Earl <patearl(at)patearl(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Full GUID support
Date: 2011-07-11 17:28:37
Message-ID: CAJOWoQ4omR8XgLbgJ0L17kNNvmgqbh-UGQ_EUHLnq6E7kwcBfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com> wrote:
> Uh.... UUID/GUID is used pervasively throughout enterprise apps, especially
> Java apps.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Pflug 2011-07-11 18:03:55 Re: Select For Update and Left Outer Join
Previous Message Gurjeet Singh 2011-07-11 17:26:34 Re: Launching debugger on self on SIGSEGV