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