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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
