Skip site navigation (1) Skip section navigation (2)

Re: Patch for UUID datatype (beta)

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Patch for UUID datatype (beta)
Date: 2006-09-18 15:14:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches
Completely agreed. I can remove the function from the patch. The
temptation was just too high not to include the new_guid() in the
patch :)

On Mon, 2006-09-18 at 10:33 -0400, Tom Lane wrote: 
> Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:
> > Isn't guaranteed uniqueness the very attribute that's expected? AFAIK
> > there's a commonly accepted algorithm providing this.
> Anyone who thinks UUIDs are guaranteed unique has been drinking too much
> of the kool-aid.  They're at best probably unique.  Some generator
> algorithms might make it more probable than others, but you simply
> cannot "guarantee" it for UUIDs generated on noncommunicating machines.
> One of the big reasons that I'm hesitant to put a UUID generation
> function into core is the knowledge that none of them are or can be
> perfect ... so people might need different ones depending on local
> conditions.  I'm inclined to think that a reasonable setup would put
> the datatype (with input, output, comparison and indexing support)
> into core, but provide a generation function as a contrib module,
> making it easily replaceable.
> 			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Albe LaurenzDate: 2006-09-18 15:15:07
Subject: Re: [PATCHES] Linking on AIX (Was: Fix linking of OpenLDAP libraries )
Previous:From: Gevik BabakhaniDate: 2006-09-18 15:13:41
Subject: Re: new language translation (.po)

pgsql-patches by date

Next:From: Harald Armin MassaDate: 2006-09-18 15:29:34
Subject: Re: [PATCHES] Patch for UUID datatype (beta)
Previous:From: Peter EisentrautDate: 2006-09-18 14:47:22
Subject: Re: [PATCHES] Patch for UUID datatype (beta)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group