2010/5/5 Vincenzo Romano <[email protected]>: > 2010/5/4 Alvaro Herrera <[email protected]>: >> Vincenzo Romano wrote: >>> Hi all. >>> >>> I'm willing to change an BIGINT ID column (actually a SERIAL8) with a >>> BIGINT whose valules are (pseudo)random. >>> The main objective is to avoid guessability. >>> I whish I could also use it as the PK (as it's now) but that's not >>> really important now. >>> Any hint? >> >> 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. Better rewrite the function for 2^64 isn't it ? > > -- > Vincenzo Romano > NotOrAnd Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Cédric Villemain -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
