Re: pg_upgrade fails saying function unaccent(text) doesn't exist - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Date
Msg-id 6e023cde-943a-5cea-8626-f1e9b29695df@aklaver.com
Whole thread Raw
In response to Re: pg_upgrade fails saying function unaccent(text) doesn't exist  (Gunnlaugur Thor Briem <gunnlaugur@gmail.com>)
Responses unaccent(text) fails depending on search_path (WAS: pg_upgrade failssaying function unaccent(text) doesn't exist)
List pgsql-general
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@aklaver.com


pgsql-general by date:

Previous
From: Mate Varga
Date:
Subject: Re: very slow largeobject transfers through JDBC
Next
From: Dave Peticolas
Date:
Subject: locate DB corruption