Re: guid/uuid datatype - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: guid/uuid datatype
Date
Msg-id 200701251826.l0PIQou27694@momjian.us
Whole thread Raw
In response to Re: guid/uuid datatype  (Neil Conway <neilc@samurai.com>)
Responses Re: guid/uuid datatype  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-patches
Neil Conway wrote:
> On Thu, 2007-01-25 at 17:57 +0100, Stefan Kaltenbrunner wrote:
> > I thought the consensus was to provide the only atatype initially and
> > look into providing the generator functions later or via an external
> > project (pgfoundry or contrib/).
>
> I don't think distributing the (portable) generator functions separately
> makes a lot of sense. For the generation methods that just depend on
> md5() or random(), we may as well include them in the backend if we're
> going to include the rest of the UUID stuff.
>
> The MAC-based generator function could also be included in the backend,
> actually: it just needs to take an argument of type "macaddr". It would
> then be up to the user (and/or various pgfoundry and contrib/ modules)
> to find a way to determine the local machine's MAC address, which
> presumably can't be done reliably in a portable fashion.

I assume we could just allow the MAC address or some unique idenfier to
be specified in postgesql.conf.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: guid/uuid datatype
Next
From: "Joshua D. Drake"
Date:
Subject: Re: guid/uuid datatype