Hello Everyone,
I have one database from odoo.sh V14 environment, when I am trying to restore it locally after the restoration process completes it raises an error, like this :
psycopg2.errors.UndefinedFunction: function unaccent_schema.unaccent(unknown, text) does not exist
LINE 2: SELECT unaccent_schema.unaccent('unaccent_sc...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:
SELECT unaccent_schema.unaccent('unaccent_schema.unaccent', $1)
CONTEXT: SQL function "unaccent" during inlining - - -
I have tried to restore it by pgAdmin 3 and with GUI and terminal also, but getting the same issue.
I have also tried to create a schema unaccent_schema.
Does anyone have any idea how to resolve it?
Regards,
Rajprasad Joshi
https://italia.rapsodoo.com/en_US/forum/it-q-a-2/question/missing-unaccent-extension-error-on-odoo14-db-import-11