Re: Help with "Create Extension unaccent"

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