Skip site navigation (1) Skip section navigation (2)

Re: default_text_search_config and expression indexes

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paesold <mpaesold(at)gmx(dot)at>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: default_text_search_config and expression indexes
Date: 2007-07-27 07:23:30
Message-ID: Pine.LNX.4.64.0707271119470.18739@sn.sai.msu.ru (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
On Fri, 27 Jul 2007, Pavel Stehule wrote:

> 2007/7/27, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>:
>> On Fri, 27 Jul 2007, Pavel Stehule wrote:
>>
>>>>
>>>>         1) Document the problem and do nothing else.
>>>>         2) Make default_text_search_config a postgresql.conf-only
>>>>            setting, thereby making it impossible to change by non-super
>>>>            users, or make it a super-user-only setting.
>>>>         3) Remove default_text_search_config and require the
>>>>            configuration to be specified in each function call.
>>>>
>>>
>>> Hello,
>>>
>>> 2+.
>>
>>
>> One of the most important purpose of integrating tsearch2 was to
>> facilitate full-text search for people in hosting environment. Usually,
>> they have no superuser rights. I'm asking don't forget about them !
>>
>> There is no problem with current behaviour once user understand what he do.
>>
>>
>
> I am not sure if postgresql is well for multilangual hosting
> environment. There is problem with locales. Without COLLATE support
> postgresql can't be used in similar environment. :(


configuration has NOTHING with language ! This is a most frequent myth about
configuration. It's just the way we chose for default_text_search_config to
use language part of locale at initdb time.
text search configuration is just a bind between parser to use for
breaking document by lexems and mapping between lexeme type and dictionaries.

>
> nice a day
> Pavel Stehule
>

 	Regards,
 		Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2007-07-27 07:32:04
Subject: Re: stats_block_level
Previous:From: Pavel StehuleDate: 2007-07-27 07:15:18
Subject: Re: default_text_search_config and expression indexes

pgsql-advocacy by date

Next:From: Pavel StehuleDate: 2007-07-27 08:15:28
Subject: Re: default_text_search_config and expression indexes
Previous:From: Pavel StehuleDate: 2007-07-27 07:15:18
Subject: Re: default_text_search_config and expression indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group