Обсуждение: Help with "Create Extension unaccent"
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
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
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.klaver@aklaver.com
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 <adrian.klaver@aklaver.com> 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.klaver@aklaver.com >
On 1/15/24 12:04, Lan Xu wrote: > Hi Adrian and Ian, > > Thank you for responding! > > OS: CentOS 7.9.2009 > Postgres: 14.5 > > It was an upgrade from an older version. From what repo? And was that same repo as the older version was installed from? > > Thanks again! Thank you for your guidance! > > Lan > >> On Jan 14, 2024, at 8:50 AM, Adrian Klaver <adrian.klaver@aklaver.com> 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.klaver@aklaver.com >> > -- Adrian Klaver adrian.klaver@aklaver.com