public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Neil Conway <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Gevik Babakhani <[email protected]>
Cc: [email protected]
Subject: Re: [DOCS] uuid type not documented
Date: Tue, 10 Apr 2007 17:25:05 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
Neil Conway <[email protected]> writes:
> On Tue, 2007-04-10 at 18:28 +0200, Peter Eisentraut wrote:
>> The problem is that most of the standard methods are platform dependent, as
>> they require MAC addresses or a "good" random source, for instance.
> http://archives.postgresql.org/pgsql-patches/2007-01/msg00392.php
> ISTM random() or similar sources is a sufficient PSRNG for the purposes
> of UUID generation -- I can't see anything in the RFC that would
> contradict that.
Doesn't seem like quite enough bits of uniqueness.
We could improve matters by incorporating the database's
pg_control.system_identifier into the UUID, substituting for the MAC
address we don't have a good way to get. system_identifier is currently
determined by the system clock at initdb time (to gettimeofday
precision), so it would add at least some additional bits of
randomness...
regards, tom lane
view thread (15+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [DOCS] uuid type not documented
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox