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

From Karsten Hilbert
Subject Re: Drawbacks of using BYTEA for PK?
Date
Msg-id 20040114094702.A625@hermes.hilbert.loc
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?
List pgsql-general
> >Remember that /sbin/ifconfig output usually include MAC address too. Not
> >that MAC addresses are 100% unique, but that should increase the
> >uniqueness.
>
> How do you increase uniqueness?  Either a value is unique or it isn't -
It increases the *likelihood* of uniqueness, IOW the expected
collision frequency.

> if you've got multiple hosts on the network with the same network
> address, you're in big trouble!
He is talking about the MAC which in itself is supposed to be
globally unique. Nothing to do with IP numbers.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Nested transaction workaround?
Next
From: Karsten Hilbert
Date:
Subject: Re: Drawbacks of using BYTEA for PK?