Re: UUID column as pimrary key? - Mailing list pgsql-general

From Anthony
Subject Re: UUID column as pimrary key?
Date
Msg-id AANLkTi=cOfTyxt1EpzKYpN6MFjdTAHT7kk=vZd2duJyg@mail.gmail.com
Whole thread Raw
In response to Re: UUID column as pimrary key?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Wed, Jan 5, 2011 at 3:43 PM, Bill Moran <wmoran@potentialtech.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.

pgsql-general by date:

Previous
From: Gary Chambers
Date:
Subject: Re: pg_dump and database size question
Next
From: Michael Satterwhite
Date:
Subject: Re: Help with trigger