Re: Pgcrypto (PostgreSQL 10) on Debain 9?

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 (PostgreSQL 10) on Debain 9?
Date: 2018-02-06 13:25:42
Message-ID: 20180206142542.37157bn9dk8l0u0w@www.gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zitat von Magnus Hagander <magnus(at)hagander(dot)net>:

> On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
> wrote:
>
> pgcrypto and uuid-ossp are both in the core package for PostgreSQL 10.

So, I take the documentation would be outdated?

But why do I get following error?
ERROR: function gen_random_uuid() does not exist.
create table ENTITY (ID uuid not null default gen_random_uuid());

--
+49 (0)1578-772 37 37
+41 (0)78 947 36 21
Ö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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Brusselback 2018-02-06 13:53:00 Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?
Previous Message Thiemo Kellner 2018-02-06 12:42:48 pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()?