Enabling unaccent module on all schemas - Mailing list pgsql-general

From Bernardo Carneiro
Subject Enabling unaccent module on all schemas
Date
Msg-id CAG5U_ADsoW=0iTj0WY2p27fpu28cVp3HZbXnsNsR9DhV4jH9+g@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello,

I've installed unaccent on the public schema using CREATE EXTENSION. However I have multiple schemas and they don't have the public schema on their search path. I've tried calling "public".unaccent() but it fails with 'text search dictionary "unaccent" does not exist'. I suppose it is trying to locate the unaccent dictionary on the wrong path because the search path does not contain public. Is there anyway to overcome this issue?

Many thanks in advance!

Cheers,
Bernardo

pgsql-general by date:

Previous
From: 高健
Date:
Subject: Re: Can dml realize the partition table's rule and make good execution plan?
Next
From: Craig Ringer
Date:
Subject: Re: Can dml realize the partition table's rule and make good execution plan?