On Tuesday 22 November 2005 21:45, Rick Schumeyer wrote: > Is there something in tsearch2 that prevents more than one index per table? > > I would like an index on field A, and a separate index on field B. > > The index builds fine for A, but gives an error for B. The error text is > > > > ERROR: could not find tsearch config by locale > >
This is not a problem with the index creation ... your tsearch2 installation is not configured for the locale your server is running. http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html See the section "TSEARCH2 CONFIGURATION". It explains, and has examples on how to set this up. cheers, Andy ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
