From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | "Moritz Sinn" <moritz(at)freesources(dot)org> |
Cc: | mloftis(at)wgops(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: function for creating random id |
Date: | 2002-04-16 16:08:01 |
Message-ID: | 20020416120801.5288958e.nconway@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 16 Apr 2002 15:14:09 +0200
"Moritz Sinn" <moritz(at)freesources(dot)org> wrote:
> Michael Loftis <mloftis(at)wgops(dot)com> writes:
>
> > I've gotten intot he habit of using a sequence identifier, and couple
> > that with the current time then md5 sum that to create unique
> > uids. Works our fairly well, and is atleast marginally difficult to
> > guess.
>
> that sounds good. could you send me your function definition? because i
> don't now how to md5 sum in postgresql.
An implementation of MD5 is part of contrib/pgcrypto.
Cheers,
Neil
P.S. I remember hearing that MD4 has been found to be vulnerable
already, and that there are some theoretical weaknesses in
MD5. Does anyone have more info on this? I personally use
SHA1 anyway...
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Hans-Juergen Schoenig | 2002-04-16 16:13:52 | Re: Triggers and System Tables |
Previous Message | Lincoln Yeoh | 2002-04-16 16:05:41 | Re: Large table update/vacuum PLEASE HELP! |