Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A105C2E007E for ; Fri, 6 Jun 2008 10:04:35 -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 86625-05 for ; Fri, 6 Jun 2008 10:04:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by developer.postgresql.org (Postfix) with ESMTP id 69C892E0038 for ; Fri, 6 Jun 2008 10:04:29 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 28805214E6F; Fri, 6 Jun 2008 15:04:27 +0200 (CEST) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: UUID generation functions Date: Fri, 6 Jun 2008 15:04:25 +0200 User-Agent: KMail/1.9.9 Cc: "Hyatt, Gordon" References: <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu> <85AC2B55AEF4CC41A2145B60C7F88074026537@JDCMAIL4.joslin.harvard.edu> In-Reply-To: <85AC2B55AEF4CC41A2145B60C7F88074026537@JDCMAIL4.joslin.harvard.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200806061504.26310.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/48 X-Sequence-Number: 29386 Am Dienstag, 3. Juni 2008 schrieb Hyatt, Gordon: > > > 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. > > Actually, I'm developing on Windows, but deploying on Linux (both the > web-server and the DB server), so a solution that is independent of > platform is the most desirable. I was hoping that PG would have something > to generate UUIDs internally. It does. Read the above link.