| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Raymond O'Donnell <rod(at)iol(dot)ie> |
| Cc: | "Thiemo Kellner, NHC Barhufpflege" <thiemo(dot)kellner(at)gelassene-pferde(dot)biz>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Pgcrypto (PostgreSQL 10) on Debain 9? |
| Date: | 2018-02-07 05:06:32 |
| Message-ID: | 20180207050632.GA1753@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 06, 2018 at 03:58:14PM +0000, Raymond O'Donnell wrote:
> On 06/02/18 13:25, Thiemo Kellner, NHC Barhufpflege wrote:
>> 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());
>
> Only a guess, but maybe you need to install the extension first? -
>
> create extension <whatever>;
For gen_random_uuid(), you need to enable pgcrypto:
create extension pgcrypto;
For a couple of other UUID-related functions, you need to enable
uuid-ossp:
create extension "uuid-ossp";
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2018-02-07 05:16:09 | Re: Fwd: postgres instalation |
| Previous Message | Jeremy Finzel | 2018-02-07 03:48:52 | Re: Alter table set logged hanging after writing out all WAL |