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

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: (psuedo) random serial for PK or at least UNIQUE NOT NULL?
Date: 2010-05-04 16:20:24
Message-ID: u2v3eff28921005040920i64c58b19j1334fea6226cbeec@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey E. Koposov 2010-05-04 16:24:26 Re: PG & random() strangeness
Previous Message Leif Biberg Kristensen 2010-05-04 16:17:22 Re: GeSHi module for Postgresql?