Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E3F572E0089 for ; Mon, 2 Jun 2008 19:15:34 -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 18050-06 for ; Mon, 2 Jun 2008 19:15:27 -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 EE3C82E0079 for ; Mon, 2 Jun 2008 19:15:30 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1K3IJJ-0003iG-Qt for pgsql-admin@postgresql.org; Mon, 02 Jun 2008 22:15:25 +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:15:25 +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:15:25 +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:15:14 +0300 Lines: 25 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: <9B722936-625A-4366-B119-6AA178372E48@pgedit.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.084 tagged_above=0 required=5 tests=AWL=-0.515, RCVD_IN_DNSWL_LOW=-1, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: * X-Archive-Number: 200806/12 X-Sequence-Number: 29350 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 -- Milen A. Radev