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 585989DC80D for ; Thu, 16 Mar 2006 06:04:11 -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 74822-03 for ; Thu, 16 Mar 2006 06:04:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id BE3189DC993 for ; Thu, 16 Mar 2006 06:04:08 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 14so323297nzn for ; Thu, 16 Mar 2006 02:04:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=KCnLGCIaeWJdzQKGFPUHlGO90s5Tbw/c96Bw+DzM2EX519OqYGYan3j67uXQwZsHa0hnvMJMoExNsgvyIxz/PenLm8D+e4kBK2FWCoHlI/JXoA/Vri8+H/ieDVS7OWIkk28xrCUC6jDsKF4AMVfejcJVisod2IV5Ko6kBGhQqG0= Received: by 10.36.113.12 with SMTP id l12mr658736nzc; Thu, 16 Mar 2006 02:04:09 -0800 (PST) Received: by 10.36.135.5 with HTTP; Thu, 16 Mar 2006 02:04:08 -0800 (PST) Message-ID: <77b69d210603160204x6f487c96oc3fe933bc32a8c04@mail.gmail.com> Date: Thu, 16 Mar 2006 15:34:08 +0530 From: "Vishal Kashyap " To: "pgsql-admin@postgresql.org" Subject: tserach2 could not find locale MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.279 required=5 tests=[AWL=0.279] X-Spam-Score: 0.279 X-Spam-Level: X-Archive-Number: 200603/128 X-Sequence-Number: 20885 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=3D# 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 =3D 'en_US' # locale for system error message strings lc_monetary =3D 'en_US' # locale for monetary formatting lc_numeric =3D 'en_US' # locale for number formatting lc_time =3D '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