> 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
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
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
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
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
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
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
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
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