Rolling forward to 10.1, new issue...

Karl Denninger <karl@xxxxxxxxxxxxx> · Thu, 11 Jan 2018 11:27:18 -0600



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

      The Market Ticker

      [S/MIME encrypted email preferred]
    
  
Attachment:
smime.p7s

Description: S/MIME Cryptographic Signature