Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A0F602E0081 for ; Mon, 2 Jun 2008 19:24:40 -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 27996-05 for ; Mon, 2 Jun 2008 19:24:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by developer.postgresql.org (Postfix) with ESMTP id 4CD982E007E for ; Mon, 2 Jun 2008 19:24:32 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1K3IS3-0004KY-3Z for pgsql-admin@postgresql.org; Mon, 02 Jun 2008 22:24:27 +0000 Received: from 77.70.61.39 ([77.70.61.39]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 Jun 2008 22:24:27 +0000 Received: from milen by 77.70.61.39 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 02 Jun 2008 22:24:27 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: UUID generation functions Date: Tue, 03 Jun 2008 01:24:19 +0300 Lines: 29 Message-ID: References: <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu> <484401E9.EE98.0025.0@wicourts.gov> <9B722936-625A-4366-B119-6AA178372E48@pgedit.com> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1251; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 77.70.61.39 User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.113 tagged_above=0 required=5 tests=AWL=-0.486, RCVD_IN_DNSWL_LOW=-1, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: * X-Archive-Number: 200806/13 X-Sequence-Number: 29351 Milen A. Radev написа: > John DeSoi написа: >> >> 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 >> >> But 8.3 still does not generate UUIDs, only stores/compares them. From >> the link above: >> >>> PostgreSQL provides storage and comparison functions for UUIDs, but >>> the core database does not include any function for generating UUIDs, >>> because no single algorithm is well suited for every application. >> >> 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? > > http://www.postgresql.org/docs/8.3/static/uuid-ossp.html My bad - just realised the OP most probably needs a Windows-compatible solution and uuid-ossp is not. -- Milen A. Radev