Answer the question
In order to leave comments, you need to log in
Postgres: Full-text search not looking on Debian for words with uppercase letters?
Postgres 9.5
Full text search works fine in test environment on my macbook. But on the VPS, it can't find any capitalized words. The problem is only with the Russian language.
This is a table created to index data for the purpose of full-text search:
CREATE TABLE public.tsv
(
name character varying NOT NULL,
id uuid NOT NULL,
tsv tsvector NOT NULL,
image boolean DEFAULT false,
source uuid,
"user" uuid,
CONSTRAINT tsv_pkey PRIMARY KEY (id),
CONSTRAINT source FOREIGN KEY (source)
REFERENCES public.source (id) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.tsv
OWNER TO postgres;
select id, name, image, type from tsv where tsv @@ to_tsquery('russian', 'кант') limit 18
"Кант – Пол Стретерн";
"2779061c-3b58-4684-890c-cc24e8f5cdc0";
"'1724–1804 –':7 '«долга»':42 '«категорическ':44 'Аристотел':18 'Имману':5 'Кант':1A,6,24,46 'Платон':16 'Пол':3A 'Стрем':19 'Стретерн':4A 'Философ':41 'границ':21 'действительн':33 'императива»':45 'классическ':10 'крупн':13 'легкост':48 'лиш':35 'мыслител':14 'немецк':9 'определ':20 'опрокидыва':49 'основоположник':8 'позна':32 'познан':23 'получ':36 'представлен':40 'результат':54 'сам':12 'совершен':59 'спекулятивн':51 'стал':58 'субъективн':39 'теор':52 'указа':25 'философ':11,55 'человек':29 'человеческ':22 '–':2A";
"2779061c-3b58-4684-890c-cc24e8f5cdc0"
CREATE DATABASE production_v2
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
CREATE DATABASE test_database
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question