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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Gunnlaugur Thor Briem <gunnlaugur(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Date: 2018-08-31 14:17:06
Message-ID: 6e023cde-943a-5cea-8626-f1e9b29695df@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Peticolas 2018-08-31 15:02:32 locate DB corruption
Previous Message Mate Varga 2018-08-31 14:15:19 Re: very slow largeobject transfers through JDBC

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-08-31 14:33:10 Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3
Previous Message Adrian Klaver 2018-08-31 14:14:18 Re: pg_upgrade fails saying function unaccent(text) doesn't exist