Horton

Re: Drawbacks of using BYTEA for PK?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Garamond <lists@zara.6.isreserved.com>
Cc: "D. Dante Lorenso" <dante@lorenso.com>, pgsql-general@postgresql.org
Date: 2004-01-12T14:50:41Z
Lists: pgsql-general 
David Garamond <lists@zara.6.isreserved.com> writes:
> Perhaps I can make a GUID by MD5( two random numbers || a timestamp || a 
> unique seed like MD5 of '/sbin/ifconfig' output)...

Adding an MD5 hash contributes *absolutely zero*, except waste of space,
to any attempt to make a GUID.  The hash will add no uniqueness that was
not there before.

			regards, tom lane