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).