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
