Re: Rolling forward to 10.1, new issue...

Keith <keith@xxxxxxxxxxx> · Fri, 12 Jan 2018 13:46:53 -0500

On Thu, Jan 11, 2018 at 1:16 PM, Karl Denninger <karl@xxxxxxxxxxxxx> wrote:

    On 1/11/2018 11:48, Tom Lane wrote:

      Karl Denninger <karl@xxxxxxxxxxxxx> writes:

        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.

      Maybe you forgot "CREATE EXTENSION"?

			regards, tom lane

    Hmmm.... this was an upgrade from 9.6 and it *was* working there --
    it's not a new install.  Wouldn't that persist across the upgrade
    and, when the "gmake install" was done on the contrib module
    wouldn't it be picked up?

    I'll check that... it makes sense but I would have expected the
    roll-forward to work seamlessly (I used pg_upgrade, not a
    dump/restore.)

    -- 

      Karl Denninger

      karl@xxxxxxxxxxxxx

      The Market Ticker

      [S/MIME encrypted email preferred]

That should persist yes. Did you install pgcrypto into a specific schema? Check the search_path of the user that is trying to use pgcrypto.

Keith