2024年1月14日(日) 14:53 Lan Xu <lanxu2000@gmail.com>:
>
> With CREATE EXTENSION unaccent, I’m getting the following:
> ERROR: extension "unaccent" has no installation script nor update path for version “1.0"
>
> But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql
For recent PostgreSQL versions, the extension files are:
unaccent--1.0--1.1.sql
unaccent--1.1.sql
so it looks like something is not right with your installation, but
without any more
details it's not possible to say what.
Regards
Ian Barwick