Re: How does the tsearch configuration get selected? - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: How does the tsearch configuration get selected?
Date
Msg-id 4672A656.50600@sigaev.ru
Whole thread Raw
In response to Re: How does the tsearch configuration get selected?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: How does the tsearch configuration get selected?
List pgsql-hackers
> 1)  Require the configuration to be always specified.  The problem with
> this is that casting (::tsquery) and operators (@@) have no way to
> specify a configuration.
it's not comfortable for most often cases

> 
> 2)  Use a GUC that you can set for the configuration, and perhaps
> default it if possible to match the locale.  Is the default affected by
> search_path (ouch)?
Right now it works so

> 
> How do we make sure that any index that is accessed is using the same
> configuration that is being used by the query, e.g. ::tsquery?  Do we
> have to store the configuration name in the index and somehow throw an
> error if it doesn't match?  What about changes to the configuration
> after the index has been created, e.g. new stop words or dictionaries?
That's possible intentional case, so we should not throw ERROR!


> 
> The two big open issues are whether we allow a default configuration,
> and whether we require the configuration name to be always specified.
> 
> My guess right now is that we use a GUC that will default if a
> pg_catalog configuration name matches the lc_ctype locale name, and we
> have to throw an error if an accessed index creation GUC doesn't match
> the current GUC.

Where will index store index creation GUC?
> 
> So we create a pg_catalog full text configuration named UTF8.en-US, and
> some others like ru_RU.UTF-8.
> 

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: How does the tsearch configuration get selected?
Next
From: Teodor Sigaev
Date:
Subject: Re: How does the tsearch configuration get selected?