Re: Pgcrypto (PostgreSQL 10) on Debain 9?
On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner <thiemo@gelassene-pferde.biz>
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 neither of the modules is installable. What did I miss?
pgcrypto and uuid-ossp are both in the core package for PostgreSQL 10.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
Import Notes
Reply to msg id not found: 20180206133742.17283hkc1u6gaew4@www.gelassene-pferde.bizReference msg id not found: 20180206133742.17283hkc1u6gaew4@www.gelassene-pferde.biz
Zitat von Magnus Hagander <magnus@hagander.net>:
On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner <thiemo@gelassene-pferde.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.
On 06/02/18 13:25, Thiemo Kellner, NHC Barhufpflege wrote:
Zitat von Magnus Hagander <magnus@hagander.net>:
On Tue, Feb 6, 2018 at 1:37 PM, Thiemo Kellner
<thiemo@gelassene-pferde.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());
Only a guess, but maybe you need to install the extension first? -
create extension <whatever>;
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie
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
Zitat von Raymond O'Donnell <rod@iol.ie>:
Only a guess, but maybe you need to install the extension first? -
create extension <whatever>;
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 those went into core in version 10.
Greetings to Galway (where I spent preparations for my CAE) from
Bannholz at the Hochrhein
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.