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 68B749DC84B for ; Thu, 16 Mar 2006 07:31:47 -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 89505-10 for ; Thu, 16 Mar 2006 07:31:49 -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 1B61E9DC849 for ; Thu, 16 Mar 2006 07:31:44 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 14so336275nzn for ; Thu, 16 Mar 2006 03:31:48 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=c3GwI3GZboMTeq2Al3oFiHEx8Fxz9puXcXPM4wEzp2XgmAldbbfsW9HvBOt0+LZAKVUswxgRtrfpODt8hEASFEdpOrMemY5cbxoShLZddd79tau2CdH6ozRDExqniltCDenNbXqU90A5H5no40QgRrqvRg72ZFd5fBzMZPTvACE= Received: by 10.37.14.56 with SMTP id r56mr2228025nzi; Thu, 16 Mar 2006 03:31:47 -0800 (PST) Received: by 10.36.135.5 with HTTP; Thu, 16 Mar 2006 03:31:47 -0800 (PST) Message-ID: <77b69d210603160331s34c3cfb8pecfda57048cfa2a5@mail.gmail.com> Date: Thu, 16 Mar 2006 17:01:47 +0530 From: "Vishal Kashyap " To: "Oleg Bartunov" , pgsql-admin@postgresql.org Subject: Re: tserach2 could not find locale In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <77b69d210603160204x6f487c96oc3fe933bc32a8c04@mail.gmail.com> <77b69d210603160320t1d13a319h4df38200c0aff61a@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.257 required=5 tests=[AWL=0.257] X-Spam-Score: 0.257 X-Spam-Level: X-Archive-Number: 200603/130 X-Sequence-Number: 20887 Dear Oleg, Thanks Oleg > use en_US.UTF-8 it works as I did test_db=3D# update pg_ts_cfg set locale =3D '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=3D# 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