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

From Chris Travers
Subject Re: Drawbacks of using BYTEA for PK?
Date
Msg-id 01cd01c3db38$99269540$7f00053d@winxp
Whole thread Raw
In response to Re: Drawbacks of using BYTEA for PK?  ("Bob Parkinson" <rwp@biome.ac.uk>)
List 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


pgsql-general by date:

Previous
From: "Chris Travers"
Date:
Subject: Re: Postgress and MYSQL
Next
From: "Chris Travers"
Date:
Subject: Re: what we need to use postgresql in the enterprise