Re: UUID column as pimrary key?

From: Anthony <osm(at)inbox(dot)org>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: UUID column as pimrary key?
Date: 2011-01-06 16:22:18
Message-ID: AANLkTi=cOfTyxt1EpzKYpN6MFjdTAHT7kk=vZd2duJyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 5, 2011 at 3:43 PM, Bill Moran <wmoran(at)potentialtech(dot)com> wrote:
> Despite the fact that the chance of a collision is very, very small, there
> is no easy way to fix it if it happens.  Zero.  It can't be done without
> shutting the system down, recalling all the remote devices and manually
> reconciling the problem ... which is not an option.

Sounds like a security problem - an intentional collision is much more
likely than a random one.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2011-01-06 16:31:38 Re: UUID column as pimrary key?
Previous Message Gary Chambers 2011-01-06 16:21:18 Re: pg_dump and database size question