| From: | "Vishal Kashyap " <vishalonlist(at)gmail(dot)com> |
|---|---|
| To: | "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: tserach2 could not find locale |
| Date: | 2006-03-16 11:31:47 |
| Message-ID: | 77b69d210603160331s34c3cfb8pecfda57048cfa2a5@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2006-03-16 14:40:37 | Curious run-away index build on upgrade to 8.1.3 |
| Previous Message | Oleg Bartunov | 2006-03-16 10:12:30 | Re: tserach2 could not find locale |