Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 093282E0080
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon,  2 Jun 2008 19:15:33 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 17981-06
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon,  2 Jun 2008 19:15:22 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by developer.postgresql.org (Postfix) with ESMTP id AA9A62E0072
	for <pgsql-admin@postgresql.org>; Mon,  2 Jun 2008 19:15:25 -0300 (ADT)
Received: from [192.168.1.5] (or-69-34-217-90.sta.embarqhsd.net
 [69.34.217.90])
	(authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m52MGk5w006184
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Mon, 2 Jun 2008 15:16:47 -0700
Subject: Re: UUID generation functions
From: "Joshua D. Drake" <jd@commandprompt.com>
To: John DeSoi <desoi@pgedit.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	Gordon Hyatt <Gordon.Hyatt@joslin.harvard.edu>, pgsql-admin@postgresql.org
In-Reply-To: <9B722936-625A-4366-B119-6AA178372E48@pgedit.com>
References: 
 <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu>
	<484401E9.EE98.0025.0@wicourts.gov>
	<9B722936-625A-4366-B119-6AA178372E48@pgedit.com>
Content-Type: text/plain
Organization: Command Prompt, Inc.
Date: Mon, 02 Jun 2008 15:18:27 -0700
Message-Id: <1212445107.12052.104.camel@jd-laptop>
Mime-Version: 1.0
X-Mailer: Evolution 2.22.1.1 
Content-Transfer-Encoding: 7bit
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Mon, 02 Jun 2008 15:16:47 -0700 (PDT)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/11
X-Sequence-Number: 29349



On Mon, 2008-06-02 at 18:11 -0400, John DeSoi wrote:
> On Jun 2, 2008, at 3:19 PM, Kevin Grittner wrote:
> 
> > Any chance of going to 8.3?
> >
> > http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html

> For reasons mentioned by the other poster, it would be helpful if  
> PostgreSQL could generate them. Is there really more than 2 or 3  
> needed options where it would be huge code bloat to include sufficient  
> alternatives?

There has been excessive discussion on UUID generation. I would check
the archives. I know that one argument that I made is that pretty much
every language has some sort of UUID generation already, including those
we use for PL languages (excluding plpgsql).

Sincerely,

Joshua D. Drake