Re: Drawbacks of using BYTEA for PK?

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: "Bob Parkinson" <rwp(at)biome(dot)ac(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Drawbacks of using BYTEA for PK?
Date: 2004-01-15 06:33:16
Message-ID: 01cd01c3db38$99269540$7f00053d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Regarding MAC address as a machine key.

I suspect that you could take md5(MAC_Address || IPV4_Address) to create a
machine ID which you can reasonably expect to be unique (i.e. the chance of
having 2 identical MAC addresses on the same IPV4 address is small enough to
disregard). I only suggest using MD5 to hide the details of the MAC and
IPV4 address from the outside world, and it is not strictly necessary for
the purposes of this discussion.

Best Wishes,
Chris Travers

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-01-15 06:55:42 Re: Schemas not created on restore
Previous Message LitelWang 2004-01-15 06:19:18 Re: about postgres odbc on wondows