| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
| Cc: | postgres(at)vrane(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: HOWTO - Random character generation for primary key |
| Date: | 2002-05-02 15:34:19 |
| Message-ID: | 20020502153419.GA26741@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Thu, May 02, 2002 at 01:01:22PM +0200,
Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Baker | 2002-05-02 16:30:52 | Re: ALTER TABLE hangs |
| Previous Message | Peter Darley | 2002-05-02 14:28:08 | Process balancing on smp db server/apache web server |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2002-05-02 15:40:37 | Re: is there a way |
| Previous Message | Alejandro Fernandez | 2002-05-02 15:30:41 | making a trigger to a system call to a shell script |