Postgres Pro
Downloads
Home   >   mailing lists

Re: Drawbacks of using BYTEA for PK? - Mailing list pgsql-general

From Tom Lane
Subject Re: Drawbacks of using BYTEA for PK?
Date
Msg-id 28405.1073919041@sss.pgh.pa.us
Whole thread Raw
In response to Re: Drawbacks of using BYTEA for PK?  (David Garamond <lists@zara.6.isreserved.com>)
Responses Re: Drawbacks of using BYTEA for PK?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: insertion with trigger failed unexpectedly
Next
From: joseph speigle
Date:
Subject: Re: PostgreeSQL C header files