Re: [GENERAL] GUID/UUID Support

2007-01-18 Thread Jeremy Haile
> Yeah, but it's not going to be added to core until there's some > agreement about *what* needs to be added. The point of the external > project is that once it has acheived a level of support *then* it can > be incorporated. That's fair. In truth, I only found that pguuid existed fairly recentl

Re: [GENERAL] GUID/UUID Support

2007-01-18 Thread Martijn van Oosterhout
On Thu, Jan 18, 2007 at 01:09:15PM -0500, Jeremy Haile wrote: > I second the desire for a UUID type in PostgreSQL! I'm aware of the > pguuid project, but it's not the same as having it in core and isn't > very well maintained. Yeah, but it's not going to be added to core until there's some agre

Re: [GENERAL] GUID/UUID Support

2007-01-18 Thread Jeremy Haile
I second the desire for a UUID type in PostgreSQL! I'm aware of the pguuid project, but it's not the same as having it in core and isn't very well maintained. This is such a common database paradigm that it seems reasonable to promote it to first-class citizen status in PostgreSQL. I currently

Re: [GENERAL] GUID/UUID Support

2007-01-18 Thread Patrick Earl
One issue is that UUIDs are only 16 bytes of data. To store the as text in canonical form requires 36 bytes. As there are alternate frequently used representations, you also run into potential issues with input. The GUID type (proposed by Gevik) handles those standard input variations. Though

Re: [GENERAL] GUID/UUID Support

2007-01-17 Thread Chad Wagner
On 1/17/07, Patrick Earl <[EMAIL PROTECTED]> wrote: Certainly support for the GUID field type itself is most important. As for the generators, though they are non-essential, they are very useful. Other platforms and libraries have standardized on uuid generators, so I don't see why PostgreSQL c

Re: [GENERAL] GUID/UUID Support

2007-01-17 Thread Patrick Earl
While using third party modules is not really a barrier for people deep in the PostgreSQL world, here is what I would need to do to use GUIDs today. 1. Get a set of GUID/UUID patches (there seem to be many) and recompile the necessary code. 2. Do the same thing for Windows, assuming that the pa

Re: [GENERAL] GUID/UUID Support

2007-01-16 Thread Chad Wagner
On 1/16/07, David Lee Lambert <[EMAIL PROTECTED]> 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 S

Re: [GENERAL] GUID/UUID Support

2007-01-16 Thread David Lee Lambert
On Tuesday 16 January 2007 05:47 pm, Patrick Earl wrote: > Greetings all. I've been poking around the web and trying to track > the status of the GUID/UUID patches. In the todo list, that item is > not marked as going into 8.3, and I feel this is unfortunate. > > [...] > > One thing that is quit

[GENERAL] GUID/UUID Support

2007-01-16 Thread Patrick Earl
Greetings all. I've been poking around the web and trying to track the status of the GUID/UUID patches. In the todo list, that item is not marked as going into 8.3, and I feel this is unfortunate. Searching google for "postgresql guid -guide" comes up with around 200,000 hits. It's obviously b