Re: GUID for postgreSQL

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Tino Wildenhain <tino(at)wildenhain(dot)de>, Riaan van der Westhuizen <riaan(at)huizensoft(dot)co(dot)za>, Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: GUID for postgreSQL
Date: 2005-07-27 20:57:21
Message-ID: 7D6824F2-9614-4DC4-B49C-C087FD6CEEA4@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jul 27, 2005, at 4:46 PM, Scott Marlowe wrote:

> So, how can two databases, not currently talking to one another,
> guarantee that their GUIDs don't collide? using a large randomly
> generated name space only reduces the chances of collision, it doesn't
> actually guarantee it.

Like MD5, there is no 100% guarantee, but the collision possibility
supposed to be is very close to zero.

See http://en.wikipedia.org/wiki/GUID

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2005-07-27 20:58:18 Re: GUID for postgreSQL
Previous Message Dann Corbit 2005-07-27 20:56:27 Re: GUID for postgreSQL