Dear Oleg,
Thanks Oleg
> use en_US.UTF-8
it works as I did
test_db=# update pg_ts_cfg set locale = 'en_US.UTF-8';
So to summarize
if you recive a error like
ERROR: could not find tsearch config by locale INSERT INTO mm_message (
Then log into the server and run the query
test_db=# show all;
lc_collate | C
lc_ctype | en_US.UTF-8 <<<<- For
tsearch2 set to this
lc_messages | en_US
lc_monetary | en_US
lc_numeric | en_US
lc_time | en_US
listen_addresses | localhost
--
With Best Regards,
Vishal Kashyap.
http://www.vishal.net.in