From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: Mon, 21 Jan 2019 15:06:19 +0000
Message-ID: <201901211506.20023.gary.stainburn@ringways.co.uk> (raw)
In-Reply-To: <201901211503.23073.gary.stainburn@ringways.co.uk>
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
<201901181642.45463.gary.stainburn@ringways.co.uk>
<201901211503.23073.gary.stainburn@ringways.co.uk>
On Monday 21 January 2019 15:03:23 Gary Stainburn wrote:
> After doing this the install worked perfectly. However, when I try to use
> the crypt() function I get the following error. I can't see what I've
> missed
>
> users=# select crypt('password','myhash');
> ERROR: function crypt(unknown, unknown) does not exist
> LINE 1: select crypt('password','myhash');
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> users=#
Sory folks, just found the answer. I need to run
create extension pgcrypto;
in each of my databases
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gary.stainburn@ringways.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
In-Reply-To: <201901211506.20023.gary.stainburn@ringways.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox