Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4DC629FB67C for ; Tue, 10 Apr 2007 16:54:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 61236-04-3 for ; Tue, 10 Apr 2007 16:54:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from master.phlo.org (master.phlo.org [213.147.174.89]) by postgresql.org (Postfix) with ESMTP id 1D0339FB24B for ; Tue, 10 Apr 2007 16:54:30 -0300 (ADT) Received: (qmail 613 invoked by uid 0); 10 Apr 2007 19:54:29 -0000 Received: from foobar.client.solution-x.com (HELO [10.100.5.180]) (fgp@[10.100.5.180]) (envelope-sender ) by master.phlo.org (qmail-ldap-1.03) with SMTP for ; 10 Apr 2007 19:54:29 -0000 Message-ID: <461BEDD4.9060709@phlo.org> Date: Tue, 10 Apr 2007 22:04:36 +0200 From: "Florian G. Pflug" User-Agent: Thunderbird 1.5.0.10 (X11/20070306) MIME-Version: 1.0 To: Neil Conway CC: Peter Eisentraut , Gevik Babakhani , pgsql-hackers@postgresql.org Subject: Re: [DOCS] uuid type not documented References: <200704101724.27285.peter_e@gmx.net> <1176219030.6558.47.camel@localhost.localdomain> <200704101828.58118.peter_e@gmx.net> <1176233452.6558.52.camel@localhost.localdomain> In-Reply-To: <1176233452.6558.52.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/451 X-Sequence-Number: 101784 Neil Conway wrote: > On Tue, 2007-04-10 at 18:28 +0200, Peter Eisentraut wrote: >> The problem is that most of the standard methods are platform dependent, as >> they require MAC addresses or a "good" random source, for instance. > > http://archives.postgresql.org/pgsql-patches/2007-01/msg00392.php > > ISTM random() or similar sources is a sufficient PSRNG for the purposes > of UUID generation -- I can't see anything in the RFC that would > contradict that. Maybe a short-term solution could be a UUID-generated function that takes some kind of seed as a parameter. People not concerned about collisons could just pass some random value, while others could use the mac-address of the client or something similar. greetings, Florian Pflug