X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 171F65334E for ; Mon, 18 Apr 2005 19:20:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11683-03 for ; Mon, 18 Apr 2005 22:20:08 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id B5BE053333 for ; Mon, 18 Apr 2005 19:20:00 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id j3IMJqRA007327; Tue, 19 Apr 2005 02:19:52 +0400 (MSD) Date: Tue, 19 Apr 2005 02:19:52 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Dan Feiveson Cc: pgsql-sql@postgresql.org Subject: Re: tsearch2 In-Reply-To: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.Com> Message-ID: References: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.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, hits=0.335 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200504/258 X-Sequence-Number: 21151 Dan, I don't remember what the probem you have ? Oleg On Mon, 18 Apr 2005, Dan Feiveson wrote: > Hi Oleg, > > Still trying to get tsearch2 to work ... from archived message board it looks like our problem is that we don't have LC_CTYPE and LC_COLLATE established. > > We're running 7.3.4 - are there any potential pitfalls if we set LC_CTYPE and LC_COLLATE (in conjunction with other settings? -- We set the locale of C on our current configuration to allow LIKE searches to use indexes - will this be affected? Also what grants do we need to run to get a non super user working with tsearch2? > > Thanks again for all your help, > > Dan > > Dan Feiveson > DataJoe LLC > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83