Re: How does the tsearch configuration get selected?

> It's not really the index's problem; IIUC the behavior of the gist and
> gin index opclasses is not locale-specific.  

Right

> It's the to_tsvector calls
> that built the tsvector heap column that have a locale specified or
> implicit.  We need some way of annotating the heap column about this.
It seems too restrictive to advanced users.

> 
> In the case of a functional index you can expose the locale:
> 
>     create index ... (to_tsvector('english'::regconfig, mytextcol))
> 
> but there's still the problem that the planner cannot match that to
> a query specified as just WHERE to_tsvector(mytextcol) @@ query.


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