Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Thiemo Kellner
Hi all I use Debian Strech (9) with PostgreSQL repository (as described on https://wiki.postgresql.org/wiki/Apt). I would like to use pgcrypto or uuid-ossp but to the contrary of 9.x there is no contribution package for 10 so neither of the modules is installable. What did I miss? Kind re

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Magnus Hagander
On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner wrote: > Hi all > > I use Debian Strech (9) with PostgreSQL repository (as described on > https://wiki.postgresql.org/wiki/Apt). I would like to use pgcrypto or > uuid-ossp but to the contrary of 9.x there is no contribution package for > 10 so neith

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Thiemo Kellner, NHC Barhufpflege
Zitat von Magnus Hagander : On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner 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

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Raymond O'Donnell
On 06/02/18 13:25, Thiemo Kellner, NHC Barhufpflege wrote: Zitat von Magnus Hagander : On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner 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 er

Re: Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Michael Paquier
On Tue, Feb 06, 2018 at 03:58:14PM +, 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

Re: [solved] Pgcrypto (PostgreSQL 10) on Debain 9?

2018-02-06 Thread Thiemo Kellner
Zitat von Raymond O'Donnell : Only a guess, but maybe you need to install the extension first? - create extension ; Thanks, right guess as I figured out yesterday evening after reading not only the module portion but the introduction to the modules. I also was mislead by the fact that