From danf@datajoe.com Mon Apr  18 21:23:54 2005
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 7DB4753322
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 18 Apr 2005 18:23:54 -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 95390-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 18 Apr 2005 21:23:52 +0000 (GMT)
Received: from hq.ncbr.com (unknown [207.174.141.130])
	by svr1.postgresql.org (Postfix) with ESMTP id E7DB65322E
	for <pgsql-sql@postgresql.org>; Mon, 18 Apr 2005 18:23:50 -0300 (ADT)
Received: from enitz2 (unknown [216.183.117.62])
	by hq.ncbr.com (Postfix) with SMTP
	id DC305153562; Mon, 18 Apr 2005 16:16:41 -0600 (MDT)
Message-ID: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.Com>
From: "Dan Feiveson" <danf@datajoe.com>
To: "Oleg Bartunov" <oleg@sai.msu.su>
Cc: <pgsql-sql@postgresql.org>
Subject: tsearch2
Date: Mon, 18 Apr 2005 15:19:36 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00F2_01C5442A.0819A220"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.075 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200504/262
X-Sequence-Number: 21155

This is a multi-part message in MIME format.

------=_NextPart_000_00F2_01C5442A.0819A220
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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


------=_NextPart_000_00F2_01C5442A.0819A220
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Oleg,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Still trying to get tsearch2 to work =
... from=20
archived message board it looks like our problem is that we don't have =
LC_CTYPE=20
and LC_COLLATE established.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>We're running 7.3.4 - are there any =
potential=20
pitfalls if we set LC_CTYPE and LC_COLLATE (in conjunction with other =
settings?=20
-- &nbsp;We set&nbsp;</FONT><FONT size=3D2><FONT face=3DArial>&nbsp;the =
locale of C=20
on our current configuration to allow LIKE searches to use indexes - =
will this=20
be affected?&nbsp;&nbsp;Also what grants do we need to run to get a non =
super=20
user working with tsearch2?</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>Thanks again for all your help,</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Dan</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Dan Feiveson</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>DataJoe LLC</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00F2_01C5442A.0819A220--




From oleg@sai.msu.su Mon Apr  18 22:20:15 2005
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <oleg@sai.msu.su>
X-X-Sender: megera@ra.sai.msu.su
To: Dan Feiveson <danf@datajoe.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: tsearch2
In-Reply-To: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.Com>
Message-ID: <Pine.GSO.4.62.0504190219320.4405@ra.sai.msu.su>
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



From danf@datajoe.com Tue Apr  19 15:42:05 2005
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 7FF1653227
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 12:42:05 -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 27123-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 15:41:58 +0000 (GMT)
Received: from hq.ncbr.com (unknown [207.174.141.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 8669752A50
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 12:41:57 -0300 (ADT)
Received: from enitz2 (unknown [216.183.117.62])
	by hq.ncbr.com (Postfix) with SMTP
	id 6CBDF153562; Tue, 19 Apr 2005 10:34:45 -0600 (MDT)
Message-ID: <003401c544f5$b8a95ab0$fb04030a@CCPlanet.Com>
From: "Dan Feiveson" <danf@datajoe.com>
To: "Oleg Bartunov" <oleg@sai.msu.su>
Cc: <pgsql-sql@postgresql.org>
References: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.Com>
	<Pine.GSO.4.62.0504190219320.4405@ra.sai.msu.su>
	<013101c54467$c58d9e00$fb04030a@CCPlanet.Com>
	<Pine.GSO.4.62.0504190747180.4405@ra.sai.msu.su>
Subject: Re: tsearch2
Date: Tue, 19 Apr 2005 09:37:40 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.058 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200504/343
X-Sequence-Number: 21236

Thanks Oleg!

Did as you recommended:

set_curcfg('default');

got new error running query containing:

 to_tsquery('advanced|tech');
 rank(avectors,a2);

ERROR:  ExecMakeTableFunctionResult: expression is not a function call

Past message board suggests this is a pg error, not tsearch2 -- do you know
of any workarounds?

Thanks for all your help Oleg,

Dan


----- Original Message ----- 
From: "Oleg Bartunov" <oleg@sai.msu.su>
To: "Dan Feiveson" <danf@datajoe.com>
Sent: Monday, April 18, 2005 10:13 PM
Subject: Re: [SQL] tsearch2


> On Mon, 18 Apr 2005, Dan Feiveson wrote:
>
> > Hi Oleg,
> >
> > Am getting when running certain functions in tsearch2:
> >
> > ERROR:  could not find tsearch config by locale
> >
> > Message boards suggest problem comes from LC_CTYPE and LC_COLLATE not
being
> > specifiec in cfg (which in our case they are not). Wondering what they
> > should be set to and if that might affect our existing settings.
>
> I see no problem if you follow instructions from documentation.
> A lot of people use tsearch2 and I don't believe your case is very
> specific. You may, at least, use set_curcfg('your_configuration_name')
> to set default configuration and show_curcfg() to see current config:
>
> test=# select oid,* from pg_ts_cfg;
>     oid   |     ts_name     | prs_name |    locale
> ---------+-----------------+----------+--------------
>   6214174 | default         | default  | C
>   6214175 | default_russian | default  | ru_RU.KOI8-R
>   6214176 | simple          | default  |
> (3 rows)
>
> test=# select show_curcfg();
>   show_curcfg
> -------------
>       6214175
> (1 row)
>
> My default config is 'default_russian' which corresponds to my locale
> setup 'ru_RU.KOI8-R' and I have no problem.  If your locale is 'C', than
> you should use 'default' configuration.
>
> test=# select set_curcfg('default');
>   set_curcfg
> ------------
>
> (1 row)
>
> test=# select show_curcfg();
>   show_curcfg
> -------------
>       6214174
> (1 row)
>
> You need to grant permission to use on tseach2 configuration tables (
pg_ts_* ).
>
>
> >
> > Thanks a lot Oleg,
> >
> > Dan
> >
> > ----- Original Message -----
> > From: "Oleg Bartunov" <oleg@sai.msu.su>
> > To: "Dan Feiveson" <danf@datajoe.com>
> > Cc: <pgsql-sql@postgresql.org>
> > Sent: Monday, April 18, 2005 4:19 PM
> > Subject: Re: [SQL] tsearch2
> >
> >
> >> 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
> >>
> >> ---------------------------(end of
broadcast)---------------------------
> >> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
> >
>
>   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




From oleg@sai.msu.su Tue Apr  19 17:43:24 2005
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 7054A53462
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 14:43:24 -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 98823-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Apr 2005 17:43:21 +0000 (GMT)
Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 8253D538D8
	for <pgsql-sql@postgresql.org>; Tue, 19 Apr 2005 14:43:12 -0300 (ADT)
Received: from ra (ra [158.250.29.2])
	by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id j3JHh2Ut005586;
	Tue, 19 Apr 2005 21:43:03 +0400 (MSD)
Date: Tue, 19 Apr 2005 21:43:02 +0400 (MSD)
From: Oleg Bartunov <oleg@sai.msu.su>
X-X-Sender: megera@ra.sai.msu.su
To: Dan Feiveson <danf@datajoe.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: tsearch2
In-Reply-To: <003401c544f5$b8a95ab0$fb04030a@CCPlanet.Com>
Message-ID: <Pine.GSO.4.62.0504192142450.28522@ra.sai.msu.su>
References: <00f501c5445c$530fc6b0$fb04030a@CCPlanet.Com>
	<Pine.GSO.4.62.0504190219320.4405@ra.sai.msu.su>
	<013101c54467$c58d9e00$fb04030a@CCPlanet.Com>
	<Pine.GSO.4.62.0504190747180.4405@ra.sai.msu.su>
	<003401c544f5$b8a95ab0$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/295
X-Sequence-Number: 21188

On Tue, 19 Apr 2005, Dan Feiveson wrote:

> Thanks Oleg!
>
> Did as you recommended:
>
> set_curcfg('default');
>
> got new error running query containing:
>
> to_tsquery('advanced|tech');
> rank(avectors,a2);
>
> ERROR:  ExecMakeTableFunctionResult: expression is not a function call
>
> Past message board suggests this is a pg error, not tsearch2 -- do you know
> of any workarounds?
>

upgrade your postgresql


> Thanks for all your help Oleg,
>
> Dan
>
>
> ----- Original Message -----
> From: "Oleg Bartunov" <oleg@sai.msu.su>
> To: "Dan Feiveson" <danf@datajoe.com>
> Sent: Monday, April 18, 2005 10:13 PM
> Subject: Re: [SQL] tsearch2
>
>
>> On Mon, 18 Apr 2005, Dan Feiveson wrote:
>>
>>> Hi Oleg,
>>>
>>> Am getting when running certain functions in tsearch2:
>>>
>>> ERROR:  could not find tsearch config by locale
>>>
>>> Message boards suggest problem comes from LC_CTYPE and LC_COLLATE not
> being
>>> specifiec in cfg (which in our case they are not). Wondering what they
>>> should be set to and if that might affect our existing settings.
>>
>> I see no problem if you follow instructions from documentation.
>> A lot of people use tsearch2 and I don't believe your case is very
>> specific. You may, at least, use set_curcfg('your_configuration_name')
>> to set default configuration and show_curcfg() to see current config:
>>
>> test=# select oid,* from pg_ts_cfg;
>>     oid   |     ts_name     | prs_name |    locale
>> ---------+-----------------+----------+--------------
>>   6214174 | default         | default  | C
>>   6214175 | default_russian | default  | ru_RU.KOI8-R
>>   6214176 | simple          | default  |
>> (3 rows)
>>
>> test=# select show_curcfg();
>>   show_curcfg
>> -------------
>>       6214175
>> (1 row)
>>
>> My default config is 'default_russian' which corresponds to my locale
>> setup 'ru_RU.KOI8-R' and I have no problem.  If your locale is 'C', than
>> you should use 'default' configuration.
>>
>> test=# select set_curcfg('default');
>>   set_curcfg
>> ------------
>>
>> (1 row)
>>
>> test=# select show_curcfg();
>>   show_curcfg
>> -------------
>>       6214174
>> (1 row)
>>
>> You need to grant permission to use on tseach2 configuration tables (
> pg_ts_* ).
>>
>>
>>>
>>> Thanks a lot Oleg,
>>>
>>> Dan
>>>
>>> ----- Original Message -----
>>> From: "Oleg Bartunov" <oleg@sai.msu.su>
>>> To: "Dan Feiveson" <danf@datajoe.com>
>>> Cc: <pgsql-sql@postgresql.org>
>>> Sent: Monday, April 18, 2005 4:19 PM
>>> Subject: Re: [SQL] tsearch2
>>>
>>>
>>>> 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
>>>>
>>>> ---------------------------(end of
> broadcast)---------------------------
>>>> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>>>
>>
>>   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
>

 	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