2024年1月14日(日) 14:53 Lan Xu <lanxu2...@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
