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

From David Garamond
Subject Re: Drawbacks of using BYTEA for PK?
Date
Msg-id 4003B849.5080309@zara.6.isreserved.com
Whole thread Raw
In response to Re: Drawbacks of using BYTEA for PK?  (Alex Satrapa <alex@lintelsys.com.au>)
Responses Re: Drawbacks of using BYTEA for PK?  (Alex Satrapa <alex@lintelsys.com.au>)
List pgsql-general
Alex Satrapa wrote:
> 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).

Remember that /sbin/ifconfig output usually include MAC address too. Not
that MAC addresses are 100% unique, but that should increase the uniqueness.

--
dave

pgsql-general by date:

Previous
From: "John Sidney-Woollett"
Date:
Subject: Re: Drawbacks of using BYTEA for PK?
Next
From: Bernd Helmle
Date:
Subject: Reallife szenario for GEQO