Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?

From: "Thiemo Kellner, NHC Barhufpflege" <thiemo(dot)kellner(at)gelassene-pferde(dot)biz>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?
Date: 2018-02-06 15:22:20
Message-ID: 20180206162220.13554p3cyco2itk4@www.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zitat von Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Neuner 2018-02-06 15:46:02 Re: Regex Replace with 2 conditions
Previous Message Tom Lane 2018-02-06 14:56:44 Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?