Re: HOWTO - Random character generation for primary key - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: HOWTO - Random character generation for primary key
Date
Msg-id 20020502153419.GA26741@wolff.to
Whole thread Raw
In response to Re: HOWTO - Random character generation for primary key  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-general
On Thu, May 02, 2002 at 01:01:22PM +0200,
  Jean-Michel POURE <jm.poure@freesurf.fr> wrote:
>
> 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?

Well what are you really trying to do? Presumably you have some reason(s)
for not wanting to use sequences, but without knowing what the reason(s)
are it is hard to give you good advice.

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: What popular, large commercial websites run
Next
From: Fran Fabrizio
Date:
Subject: Re: Joe Celko Function