Re: [HACKERS] Patch for UUID datatype (beta) - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [HACKERS] Patch for UUID datatype (beta)
Date
Msg-id 20060920032151.GF31466@alvh.no-ip.org
Whole thread Raw
In response to Re: [HACKERS] Patch for UUID datatype (beta)  (mark@mark.mielke.cc)
Responses Re: [HACKERS] Patch for UUID datatype (beta)
List pgsql-patches
mark@mark.mielke.cc wrote:
> On Tue, Sep 19, 2006 at 08:20:13AM -0500, Jim C. Nasby wrote:
> > On Mon, Sep 18, 2006 at 07:45:07PM -0400, mark@mark.mielke.cc wrote:
> > > I would not use a 100% random number generator for a UUID value as was
> > > suggested. I prefer inserting the MAC address and the time, to at
> > > least allow me to control if a collision is possible. This is not easy
> > > to do using a few lines of C code. I'd rather have a UUID type in core
> > > with no generation routine, than no UUID type in core because the code
> > > is too complicated to maintain, or not portable enough.
> > As others have mentioned, using MAC address doesn't remove the
> > possibility of a collision.
>
> It does, as I control the MAC address.

What happens if you have two postmaster running on the same machine?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Dynamic linking on AIX
Next
From: "Merlin Moncure"
Date:
Subject: Fwd: docs for advisory locks