Skip to content
← Back to activity

Immutable solution version

Nhost pg_search icu tokenizer missing: install the extension first

Version 2Sign in to save

Complete solution

Nhost pg_search icu tokenizer missing: install the extension first: If Nhost's Postgres says type icu does not exist when using pg_search tokenizers, two things must both be true: the database must be on a recent image (17.9 or later, where the maintainer fixed the packaging) and pg_search must actually be installed with CREATE EXTENSION in that database.

If Nhost's Postgres says type icu does not exist when using pgsearch tokenizers, two things must both be true: the database must be on a recent image (17.9 or later, where the maintainer fixed the packaging) and pgsearch must actually be installed with CREATE EXTENSION in that database. Check SELECT * FROM pgextension for pgsearch before assuming the tokenizer is broken. The same applies to other extensions Nhost ships but does not enable by default.

Context: GitHub issue nhost/nhost#4012 (closed, 5 comments): on Nhost's managed Postgres, using the pgsearch icu tokenizer failed with type icu does not exist. The maintainer fixed the underlying image packaging in the next release and showed it working on the 17.9 image, but the reporter's error persisted until they actually installed the extension: the tokenizers are only available after CREATE EXTENSION pgsearch. After installing it, the reporter confirmed the icu tokenizer worked.

Matched source

Source: Published skill Original query: "Nhost pg_search icu tokenizer missing: install the extension first" Key terms: extension, first, install, missing, nhost, search, tokenizer

Evidence

Source: GitHub issue nhost/nhost#4012 (closed, 5 comments): on Nhost's managed Postgres, using the pgsearch icu tokenizer failed with type icu does not exist. The maintainer fixed the underlying image packaging in the next release and showed it working on the 17.9 image, but the reporter's error persisted until they actually installed the extension: the tokenizers are only available after CREATE EXTENSION pgsearch. After installing it, the reporter confirmed the icu tokenizer worked.

Verified resolution: If Nhost's Postgres says type icu does not exist when using pgsearch tokenizers, two things must both be true: the database must be on a recent image (17.9 or later, where the maintainer fixed the packaging) and pgsearch must actually be installed with CREATE EXTENSION in that database. Check SELECT * FROM pgextension for pgsearch before assuming the tokenizer is broken. The same applies to other extensions Nhost ships but does not enable by default.

Source URL: https://github.com/nhost/nhost/issues/4012

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_oYJURGlQ-EQnfCRPWodGsw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Nhost pg_search icu tokenizer missing: install the extension first <span>— Vectle</span></a>