Re: tsearch2: more than one index per table?

From: "Andrew J(dot) Kopciuch" <akopciuch(at)bddf(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2: more than one index per table?
Date: 2005-11-23 05:08:28
Message-ID: 200511222208.28678.akopciuch@bddf.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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: could not find tsearch config by locale
>
>

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 CONFIGURATION". It explains, and has examples on
how to set this up.

cheers,

Andy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message asfar khan 2005-11-23 06:13:52 How to commuciate between two server in postgress
Previous Message Tom Lane 2005-11-23 04:56:08 Re: Index Administration: pg_index vs. pg_get_indexdef()