Re: Drawbacks of using BYTEA for PK?

Alex Satrapa <alex@lintelsys.com.au>

From: Alex Satrapa <alex@lintelsys.com.au>
To: pgsql-general@postgresql.org
Date: 2004-01-12T22:40:37Z
Lists: pgsql-general
David Garamond wrote:
> Perhaps I can make a GUID by MD5( two random numbers || a timestamp || a 
> unique seed like MD5 of '/sbin/ifconfig' output)...

As long as you don't use RFC1918 addresses, the IPv4 address(es) of the 
host should be unique for the Internet. Append/prepend a 32 bit 
timestamp and you have a 64bit unique identifier that is "universally" 
unique (to one second).