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