X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9514C9DC959 for ; Thu, 16 Mar 2006 06:12:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76415-03 for ; Thu, 16 Mar 2006 06:12:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by postgresql.org (Postfix) with ESMTP id 0334E9DC9BD for ; Thu, 16 Mar 2006 06:12:30 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id k2GACUBs027676; Thu, 16 Mar 2006 13:12:31 +0300 (MSK) Date: Thu, 16 Mar 2006 13:12:30 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Vishal Kashyap cc: "pgsql-admin@postgresql.org" Subject: Re: tserach2 could not find locale In-Reply-To: <77b69d210603160204x6f487c96oc3fe933bc32a8c04@mail.gmail.com> Message-ID: References: <77b69d210603160204x6f487c96oc3fe933bc32a8c04@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.441 required=5 tests=[AWL=-0.038, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.441 X-Spam-Level: X-Archive-Number: 200603/129 X-Sequence-Number: 20886 Read http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes and provide us more info about your setup. Check 'show all' output for locale setup Oleg On Thu, 16 Mar 2006, Vishal Kashyap wrote: > Hi all , > > tsearch2 is giving me jitters for days now and after full > investigation I am writting into list. > > The error is > > ERROR: could not find tsearch config by locale INSERT INTO mm_message ( > > The investigation is > > my_db=# select * from pg_ts_cfg; > ts_name | prs_name | locale > -----------------+----------+-------------- > default | default | C > default_english | default | en_US > default_russian | default | ru_RU.KOI8-R > simple | default | > > postresql.conf file says > > lc_messages = 'en_US' # locale for system error message strings > lc_monetary = 'en_US' # locale for monetary formatting > lc_numeric = 'en_US' # locale for number formatting > lc_time = 'en_US' # locale for time formatting > > > > Please guide me how do I get rid of this error > -- > With Best Regards, > Vishal Kashyap. > http://www.vishal.net.in > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83