Re: HOWTO - Random character generation for primary key

Le Jeudi 2 Mai 2002 12:13, postgres@vrane.com a écrit :
> > Le Jeudi 2 Mai 2002 11:30, postgres@vrane.com a écrit :
> > > Untrue.  I am using email addresses
> > > as primary keys in a table.  Where
> > > did you get that information?
> >
> > Sorry, I did not mean that of course. I posted this small howto in reply
> > to a mail. It shows how to create a VACHAR PRIMARY KEY with unique random
> > values.
> > On 10 character lenght, there is approximatively one chance out of 26^10
> > to have a similar value. If you add a string timestamp, like
> > "20020501_1153_" in front of the random value, it is very likely that
> > this value will be UNIQUE in the word:
>
> In the real world "very likely" is not good enough.  Can you gurantee
> 'uniqueness'?

A timestamp (ex: 20020501_1258) followed by PLpgSQL function
random_string(200) value should provide a unique signature. What do you
think? Alternatively, could we use the crypto package to generate a unique
signature?

Cheers,
Jean-Michel POURE