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

From Alex Satrapa
Subject Re: Drawbacks of using BYTEA for PK?
Date
Msg-id 40032265.5010000@lintelsys.com.au
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
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).


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump/Restore ordering problem?
Next
From: "scott.marlowe"
Date:
Subject: Re: Vacuum Error