Re: BUG #12126: Empty tsvector as output ofto_tsvector function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12126: Empty tsvector as output ofto_tsvector function
Date
Msg-id 17136.1417623510@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #12126: Empty tsvector as output ofto_tsvector function  (Marcin Ogorzałek <marcin.ogorzalek@jmkcomputerate.pl>)
List pgsql-bugs
=?UTF-8?Q?Marcin_Ogorza=C5=82ek?= <marcin.ogorzalek@jmkcomputerate.pl> writes:
> W dniu 02.12.2014 18:18, Tom Lane napisał(a):
>> What have you got default_text_search_config set to?  Have you changed
>> any of the files within the installation directory's
>> share/tsearch_data/
>> subdirectory?

> After this message I've checked several things and problem was that
> default_text_search_config set to pg_catalog.simple was unable to
> recognize the text.
> Only setting the regconfig parameter explicitly to 'english' gave the
> results.

I had tried both 'english' and 'simple' on your example, and they gave
slightly different but certainly nonempty results.  I continue to suspect
there's something corrupt about either your text search configuration
files, or the description of the 'simple' configuration in the catalogs.

            regards, tom lane



pgsql-bugs by date:

Previous
From: abdulrahman Alotaibi
Date:
Subject: Locale breaks psql
Next
From: Flavio Henrique Araque Gurgel
Date:
Subject: ALTER TABLE documentation or parser bug