From 8bac1c7067718f7908d461a0a3c3d3b029ff78b1 Mon Sep 17 00:00:00 2001 From: Michael Ritter Date: Tue, 16 Dec 2025 13:31:16 -0700 Subject: [PATCH] DRYD-1834: Remove Unnecessary Namespace Search (#490) Avoid namespace search for cspace_english --- .../unaccent_text_search_configuration.sql | 17 +---------------- 1 file changed, 1 insertion(+), 16 deletions(-) diff --git a/services/common/src/main/resources/db/postgresql/unaccent_text_search_configuration.sql b/services/common/src/main/resources/db/postgresql/unaccent_text_search_configuration.sql index 72ec6968a..f6d71da68 100644 --- a/services/common/src/main/resources/db/postgresql/unaccent_text_search_configuration.sql +++ b/services/common/src/main/resources/db/postgresql/unaccent_text_search_configuration.sql @@ -19,22 +19,7 @@ BEGIN WITH unaccent, english_stem; CREATE OR REPLACE FUNCTION nx_to_tsvector(string VARCHAR) RETURNS TSVECTOR AS $func$ - DECLARE - search_namespace TEXT; - result TSVECTOR; - BEGIN - SELECT - nspname INTO search_namespace - FROM - pg_namespace - INNER JOIN pg_ts_config ON pg_namespace.oid = pg_ts_config.cfgnamespace - AND cfgname = 'cspace_english' :: text; - - PERFORM set_config('search_path', search_namespace, true); - - result := TO_TSVECTOR('cspace_english', SUBSTR($1, 1, 250000)); - RETURN result; - END; + SELECT TO_TSVECTOR('cspace_english', SUBSTR($1, 1, 250000)); $func$ LANGUAGE plpgsql IMMUTABLE; END IF; END IF; -- 2.47.3