Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? - Mailing list pgsql-general

From Thiemo Kellner, NHC Barhufpflege
Subject Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?
Date
Msg-id 20180206162220.13554p3cyco2itk4@www.gelassene-pferde.biz
Whole thread Raw
In response to Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Zitat von Tom Lane <tgl@sss.pgh.pa.us>:

> I believe the point of the recommendation is that if you only need type-4
> UUIDs, you can get that from pgcrypto without needing the external
> dependency of the OSSP UUID library.  This is a bit less urgent than when
> that text was written, because now we also support building that contrib
> module against some other implementations; but there are still going to
> be systems on which installing uuid-ossp is inconvenient.
>
> There may also be a belief that pgcrypto's result is more
> cryptographically secure, though I wouldn't swear to that.

Thanks for the light :-)

Kind regards Thiemo


--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?
Next
From: George Neuner
Date:
Subject: Re: Regex Replace with 2 conditions