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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: default_text_search_config and expression indexes


  • From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
  • To: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
  • 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. 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: Fri, 27 Jul 2007 09:15:18 +0200
  • Message-id: <162867790707270015t13ddfc5ar47ef41382afa0ac0(at)mail(dot)gmail(dot)com>

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. :(

nice a day
Pavel Stehule



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group