Re: Drawbacks of using BYTEA for PK?

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Drawbacks of using BYTEA for PK?
Date: 2004-01-13 09:20:09
Message-ID: 4003B849.5080309@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bernd Helmle 2004-01-13 09:50:22 Reallife szenario for GEQO
Previous Message John Sidney-Woollett 2004-01-13 08:50:05 Re: Drawbacks of using BYTEA for PK?