Re: BUG #12126: Empty tsvector as output of to_tsvector function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Ogorzałek <marcin(dot)ogorzalek(at)jmkcomputerate(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12126: Empty tsvector as output of to_tsvector function
Date: 2014-12-03 16:18:30
Message-ID: 17136.1417623510@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?Q?Marcin_Ogorza=C5=82ek?= <marcin(dot)ogorzalek(at)jmkcomputerate(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Flavio Henrique Araque Gurgel 2014-12-03 17:19:42 ALTER TABLE documentation or parser bug
Previous Message Hendrik Grewe 2014-12-03 11:21:14 Re: BUG #11949: pg_basebackup creates defective tar file