Re: Still wondering about random numbers...

Joe Conway <joseph.conway@home.com>

From: "Joe Conway" <joseph.conway@home.com>
To: <lockhart@fourpalms.org>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Dr. Evil" <drevil@sidereal.kz>, <pgsql-general@postgresql.org>
Date: 2001-08-07T16:53:15Z
Lists: pgsql-general
> > > Looks like plain old C library random numbers. If you want to use
> > > /dev/random or /dev/urandom, best bet would be to write your own C
function.
> > > You should also check through the contrib stuff -- I don't recall
seeing RNG
> > > functions in there,
> > I don't see any in there either, but this seems like a fine candidate
for
> > a contrib item.  I doubt we'd accept it into the mainstream for lack of
> > portability, but as a contrib item, why not?
>
> configure is our friend. A better random number generator is always
> welcome imho, and if it can be reliably supported through autoconf then
> it would stand a chance to be included in the main tree. Especially
> since the usage of random() seems to be very isolated in the code.
> contrib/ is always a good first step though...
>
>                     - Thomas

Sounds like there's some interest in this. I just wrote a function for
generating random initialization vectors from /dev/urandom within the past
week -- should be easy to make a pgsql contrib out of it. I'll send
something to patches in a couple of days or so.

-- Joe