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