Re: Drawbacks of using BYTEA for PK?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Drawbacks of using BYTEA for PK?
Date: 2004-01-14 08:47:03
Message-ID: 20040114094702.A625@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-01-14 09:21:50 Re: Drawbacks of using BYTEA for PK?
Previous Message Martijn van Oosterhout 2004-01-14 08:41:52 Re: Nested transaction workaround?