Re: The default text search configuration will be set to "simple" ?

Stefan Schwarzer wrote:
>> properly. What operating-system (and version) are you running, and
>> what version of PG, and did you compile it from source or get it
>> elsewhere?
>
> I am running 10.5, on a MacPro. Postgres version 8.3.1 and got it from
> macports.
>
> A bit ago, in my many attempts to get postgres & postgis running on
> 10.5, I added this to the .bash_profile:
>
> adding to .bash_profile:
> LANG=en_US.UTF-8; export LANG
> export PATH="/opt/local/lib/postgresql83/bin:$PATH"

Hmm - very strange. Your LANG setting seems sensible, and I did
something similar on my Mac to get subversion to work. It could be that
the postgres user-account isn't importing these settings, but it
certainly seemed to get time/money/etc correct.

> And then, something which didn't work before, did work finally. But I am
> not eager to try it out now, because I am happy enough that my
> postgres&postgis is finally running...

If it's nothing to do with the language settings, I'd check you have the
relevant files for tsearch. Look in $SHAREDIR/tsearch_data for a bunch
of <language>.stop files and perhaps .dict or .affix files

You can find out where your sharedir is with "pg_config --sharedir".

--
   Richard Huxton
   Archonet Ltd