Enabling unaccent module on all schemas

Поиск
Список
Период
Сортировка
От Bernardo Carneiro
Тема Enabling unaccent module on all schemas
Дата
Msg-id CAG5U_ADsoW=0iTj0WY2p27fpu28cVp3HZbXnsNsR9DhV4jH9+g@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: 高健
Дата:
Сообщение: Re: Can dml realize the partition table's rule and make good execution plan?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Can dml realize the partition table's rule and make good execution plan?