Date: Wed, 11 Apr 2007 07:28:17 +0200
From: Roman Neuhauser <neuhauser@sigpipe.cz>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Neil Conway <neilc@samurai.com>, Peter Eisentraut <peter_e@gmx.net>,
	Gevik Babakhani <pgdev@xs4all.nl>, pgsql-hackers@postgresql.org
Subject: Re: [DOCS] uuid type not documented
Message-ID: <20070411052817.GA59225@dagan.sigpipe.cz>
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>
	<461BEA34.2040601@dunslane.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <461BEA34.2040601@dunslane.net>
User-Agent: Mutt/1.5.13 (2006-08-11)

# andrew@dunslane.net / 2007-04-10 15:49:08 -0400:
> 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.
> >
> >  
> 
> How about we set up a contrib (I wish we'd fixed that) module with an 
> example function or two?

Thought I'd mention Ralph Engelschall's uuid library, comes with
a PostgreSQL binding:

http://www.ossp.org/pkg/lib/uuid/
http://cvs.ossp.org/fileview?f=ossp-pkg/uuid/pgsql/uuid.txt&v=1.1

I only played with it some time ago.

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991