From: Karl Denninger <karl@denninger.net>
To: pgsql-admin@postgresql.org
Subject: Rolling forward to 10.1, new issue...
Date: Thu, 11 Jan 2018 11:27:18 -0600
Message-ID: <77e478d5-2d89-2d7d-18af-0a786070b88a@denninger.net> (raw)
I'm starting to roll forward to 10.1 in a couple of places and have run
into a very odd problem -- the "pgcrypto" functions disappeared.
I've got the contrib module loaded but the functions are not there. For
example:
pgsql=# select crypt('test', gen_salt('md5'));
ERROR: function gen_salt(unknown) does not exist
LINE 1: select crypt('test', gen_salt('md5'));
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
I shut down the server in question, went back and re-made the pgcrypto
contrib directory (it HAD been installed previously) and re-did the
install, then restarted the server -- no change. I've never seen this
problem before....
Not quite sure where to look next..... any ideas?
--
Karl Denninger
karl@denninger.net <mailto:karl@denninger.net>
/The Market Ticker/
/[S/MIME encrypted email preferred]/
Attachments:
smime.p7s (application/pkcs7-signature, 4.8K) download
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: karl@denninger.net
Subject: Re: Rolling forward to 10.1, new issue...
In-Reply-To: <77e478d5-2d89-2d7d-18af-0a786070b88a@denninger.net>
* 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