Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPTCm-00BoRl-Bz for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 20:05:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPTCk-00HVO8-Tb for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 20:05:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPTCk-00HVNz-IR for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 20:05:06 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPTCd-001hVo-U4 for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 20:05:05 +0000 Received: by mail-pf1-x429.google.com with SMTP id d2e1a72fcca58-6d9b13fe9e9so7099347b3a.2 for ; Mon, 15 Jan 2024 12:04:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705349099; x=1705953899; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=B4GMU8FT6mk36vbv3oTKgV4kB+QXMAnqVyBeNOZNNAs=; b=FKgpAcpzhi+5wJMxjYePdepoDL8MrG3tFJcAsDgvmv1xWHtB+FNKaLWmMZtD6QRxja uMDtVogItk4FOujnxdZ7qiro8COs4dYhTIKt14jxZncK6S9N5K/HG6penuGYqDQX0QFC yDfUyvn+BhotAMImn+X8aaR56p7U3px1Qt+YIanJBJGblq7oW3J1NWI82nxNhJns4lOR Nh16x3UVc1BNqjL9Y3f+2rs5ctX3K0J0c/NP372QDWe8DXGQvbzVmRRKDjSj+HVjzCky 0TWEQaj4Z+zsGVF/n+QJ5exWTT3gj7vRpED/ob6UUMuyJz2q0v2dLh5N3ownzVO7JkEX MBww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705349099; x=1705953899; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=B4GMU8FT6mk36vbv3oTKgV4kB+QXMAnqVyBeNOZNNAs=; b=j9at07iPldHg4PC8ORNROduMHCX8P2CDAR7WpiOf1bO/2Z7MrY8odJdlH47Pp4tOWp 8/nxVr5vbkOSEn4KTMBTCZYpQnOP6CH8nXFjL3frUYIV+bdtb6M50ebXA3Ens9s6svBz anUZXXt8NitW2YwHr5H5rlhhqqyuf58s3+wQ3HyNIjxDqWkhzxZeMPqrqgA5X7LAMhAW S5PIIZ/p2anLDB17M358CQSYHzGY675x5B/c23+XPEuPhuu1AeJFRA9QJw9A+1gyKcDZ HHW4ukJ/bTD58UzU5B7XcOdpewdWsqG0S3bm1e16qsAsFGlHP6T7wP8E9YcftvQO/2jS eGzw== X-Gm-Message-State: AOJu0Ywc1rnXm0QZzHC8heNbTvQz4VSAKIj7ur23MBfE49EsLSRHP62G HbBvpk//qCH42MK1wZfW03g= X-Google-Smtp-Source: AGHT+IG4TbfxXdbT32DXH+vGC95oUSIryCsUTPbdRheUy9JCqy8iTgUTVyM8Ake//UwU5nKUo44c3A== X-Received: by 2002:a05:6a00:1399:b0:6db:74c8:6e58 with SMTP id t25-20020a056a00139900b006db74c86e58mr4142062pfg.10.1705349098880; Mon, 15 Jan 2024 12:04:58 -0800 (PST) Received: from smtpclient.apple (c-98-42-210-28.hsd1.ca.comcast.net. [98.42.210.28]) by smtp.gmail.com with ESMTPSA id b6-20020aa78106000000b006db11bab9d9sm7959863pfi.202.2024.01.15.12.04.57 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 15 Jan 2024 12:04:58 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.200.91.1.1\)) Subject: Re: Help with "Create Extension unaccent" From: Lan Xu In-Reply-To: Date: Mon, 15 Jan 2024 12:04:46 -0800 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <35FEDB70-57AE-45B6-874A-C9D628371A5D@gmail.com> To: Adrian Klaver , barwick@gmail.com X-Mailer: Apple Mail (2.3774.200.91.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Adrian and Ian,=20 Thank you for responding!=20 OS: CentOS 7.9.2009 Postgres: 14.5 It was an upgrade from an older version.=20 Thanks again! Thank you for your guidance! Lan > On Jan 14, 2024, at 8:50=E2=80=AFAM, Adrian Klaver = wrote: >=20 > On 1/13/24 21:52, Lan Xu wrote: >> With CREATE EXTENSION unaccent, I=E2=80=99m getting the following: >> ERROR: extension "unaccent" has no installation script nor update = path for version =E2=80=9C1.0" >> But I can find it under /usr/share/pgsql/extension/unaccent001.0.sql >> Thank you for your help! >=20 > What OS and version? >=20 > What Postgres version? >=20 > How did you install Postgres? >=20 >> Lan >=20 > --=20 > Adrian Klaver > adrian.klaver@aklaver.com >=20