Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?
Date: 2010-05-05 10:46:31
Message-ID: t2n3eff28921005050346j4ba439fcs37784de7bf2d90d8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>>> http://wiki.postgresql.org/wiki/Pseudo_encrypt
>> That's a nice starting point.
>> I should apply that function twice for each 32-bit chunk of a
>> 64-bit BIGINT and then merge the results into a single BIGINT ...
>> Boring but doable!
>
> Hum, not sure. If I understand correctly, you won't be able to get the
> original int64 from the generated one.

Why should I bother?

> Better rewrite the function for 2^64 isn't it ?

Sure!.

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cédric Villemain 2010-05-05 11:01:49 Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?
Previous Message Cédric Villemain 2010-05-05 10:43:22 Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?