Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3625D2E011A for ; Tue, 3 Jun 2008 10:45:54 -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 37755-09 for ; Tue, 3 Jun 2008 10:45:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by developer.postgresql.org (Postfix) with ESMTP id 4BC0B2E00F1 for ; Tue, 3 Jun 2008 10:44:59 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so117916yxb.73 for ; Tue, 03 Jun 2008 06:44:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=ZSFUGBBy3WFmLfbB92FeIPkXns58Mof2wBaPkKoY+j4=; b=Ywh+E7iigGxfPQlTrKduPVujZ8ccVh9CKD/+9cjJS63PbDxtrKagbS6XZoYHPEAnqw5WfGqVUbyhmy8EG/RXDPtwzEhRzi2eEfgbbdZUi74BNB4fw5sSGipH6hGHytrE5YbWR/pfLB8ZFPR3X/2KWuzyQ43hU4/ibrwpXm/wXRs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=rvRrSreM6RdurgHmJ2UfW14yci9xBkcQN/rNXc3VG0NgQpe8xv0Yo+L1mVGUfsehApRARmm0jsC3Aw82ja8I7VVzVi7ky2c8nGJRBpDjHSiivYWIfsSO676m2myOr+MF9nTG4iQvsC+7zQJVst+nr6ZeVY6dQSrgVIz837rgiw8= Received: by 10.151.98.16 with SMTP id a16mr15133664ybm.233.1212500697756; Tue, 03 Jun 2008 06:44:57 -0700 (PDT) Received: from ?192.168.100.178? ( [205.214.220.146]) by mx.google.com with ESMTPS id e17sm4452644qbe.9.2008.06.03.06.44.51 (version=SSLv3 cipher=RC4-MD5); Tue, 03 Jun 2008 06:44:56 -0700 (PDT) Message-ID: <48454A86.3050304@gmail.com> Date: Tue, 03 Jun 2008 09:43:34 -0400 From: Rommel the iCeMAn User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: UUID generation functions References: <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu> <484401E9.EE98.0025.0@wicourts.gov> <9B722936-625A-4366-B119-6AA178372E48@pgedit.com> In-Reply-To: Content-Type: text/plain; charset=windows-1251; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.191 tagged_above=0 required=5 tests=AWL=-0.926, RCVD_IN_SORBS_WEB=1.117 X-Spam-Level: X-Archive-Number: 200806/18 X-Sequence-Number: 29356 >> But 8.3 still does not generate UUIDs, only stores/compares them This is true, however, only last week I completed a successful pg 8.3 install and during the installation I was able to include UUID generation functions as an option. I now have 10 functions called uuid_something. The ones I use most begin with "uuid_generate". I can call these functions from within my own stored procs. Rommel the iCeMAn Barbados, Caribbean.