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
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
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
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
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
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