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?