On Wednesday 23 November 2005 06:55, Rick Schumeyer wrote:
> I apologize if I'm being dense, but I'm not completely following the
> explanation. It is true that my pg_ts_cfg.locale is set to en_US.UTF-8.
>
> It was my understanding that specifying "default" as in
>
That takes the locale that is s
thing to table.
Don't resist and configure tsearch2 to match server's locale.
It's most painless way.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Andrew J. Kopciuch
Sent: Wednesday, November 23, 2005 12:08 AM
To: pgsql
ong about this?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Andrew J. Kopciuch
> Sent: Wednesday, November 23, 2005 12:08 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] tsearch2: more than one ind
On Tue, 22 Nov 2005, Andrew J. Kopciuch wrote:
This is not a problem with the index creation ... your tsearch2 installation
is not configured for the locale your server is running.
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
See the section "TSEARCH2 CONFI
On Tuesday 22 November 2005 21:45, Rick Schumeyer wrote:
> Is there something in tsearch2 that prevents more than one index per table?
>
> I would like an index on field A, and a separate index on field B.
>
> The index builds fine for A, but gives an error for B. The error text is
>
>
>
> ERROR:
On Wed, 23 Nov 2005, Teodor Sigaev wrote:
ERROR: could not find tsearch config by locale
UPDATE t SET idxA=to_tsvector('default', a);
Is it working
select to_tsvector('foo bar')?
I suppose, no. In that case tsearch can't find configuration for current
database locale, update pg_ts_cfg.loca
ERROR: could not find tsearch config by locale
UPDATE t SET idxA=to_tsvector('default', a);
Is it working
select to_tsvector('foo bar')?
I suppose, no. In that case tsearch can't find configuration for current
database locale, update pg_ts_cfg.locale in wished row to correct value.
--
Teo
Is there something in tsearch2 that prevents more than one
index per table?
I would like an index on field A, and a separate index on
field B.
The index builds fine for A, but gives an error for B.
The error text is
ERROR: could not find tsearch config by locale
The code below