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

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?
Date: 2018-02-06 12:42:48
Message-ID: 20180206134248.16313350klvadi2o@www.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I consider using uuid as primary key type. The documentation of
uuid-ossp states
(https://www.postgresql.org/docs/10/static/uuid-ossp.html#idm46428633607040)
makes a note to consider the pgcrypto function instead but not why.
Can somebody shed some light on that matter?

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner, NHC Barhufpflege 2018-02-06 13:25:42 Re: Pgcrypto (PostgreSQL 10) on Debain 9?
Previous Message Thiemo Kellner 2018-02-06 12:37:42 Pgcrypto (PostgreSQL 10) on Debain 9?