Help with "Create Extension unaccent"

2024-01-13 Thread Lan Xu 
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

Thank you for your help!

Lan

Re: Help with "Create Extension unaccent"

2024-01-15 Thread Lan Xu 
Hi Adrian and Ian, 

Thank you for responding! 

OS: CentOS 7.9.2009
Postgres: 14.5

It was an upgrade from an older version. 

Thanks again! Thank you for your guidance!

Lan

> On Jan 14, 2024, at 8:50 AM, Adrian Klaver  wrote:
> 
> On 1/13/24 21:52, Lan Xu wrote:
>> 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
>> Thank you for your help!
> 
> What OS and version?
> 
> What Postgres version?
> 
> How did you install Postgres?
> 
>> Lan
> 
> -- 
> Adrian Klaver
> adrian.kla...@aklaver.com
>