Re: tserach2 could not find locale - Mailing list pgsql-admin

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