Re: pg_upgrade fails saying function unaccent(text) doesn't exist

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 08/30/2018 09:03 AM, Gunnlaugur Thor Briem wrote:
> \dFd unaccent
> List of text search dictionaries
>   Schema |   Name   | Description
> --------+----------+-------------
>   public | unaccent |
> (1 row)
>
> \dFd+ unaccent
>                      List of text search dictionaries
>   Schema |   Name   |    Template     |    Init options    | Description
> --------+----------+-----------------+--------------------+-------------
>   public | unaccent | public.unaccent | rules = 'unaccent' |
> (1 row)
>
> Cheers,
> Gulli

Forgot to add to previous post:

\dx unaccent
                       List of installed extensions
   Name   | Version | Schema |                 Description
----------+---------+--------+---------------------------------------------
 unaccent | 1.1     | public | text search dictionary that removes accents



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx