Re: Tsearch vector not stored by update/set - Mailing list pgsql-general

From Justin L. Kennedy
Subject Re: Tsearch vector not stored by update/set
Date
Msg-id Pine.SOL.4.33.0503220949130.6060-100000@acmex.gatech.edu
Whole thread Raw
In response to Re: Tsearch vector not stored by update/set  ("Andrew J. Kopciuch" <akopciuch@bddf.ca>)
List pgsql-general
On Mon, 21 Mar 2005, Andrew J. Kopciuch wrote:
> If you look at your config mappings for the "default_english" you will notice
> that you have 16 records, as opposed to 19 records like every other
> configuration mapping.  From some more in depth observations, I noticed you
> are missing entries for the 'lword', 'lhword' and ''lpart_hword'.  That means
> that tokens found to be of types 'Latin Words', 'Latin Hyphenated Words' and
> 'Latin Part Hyphenated Words' are just dropped because you do not have a
> configuration mapping set up for them.

You were correct.  It was these missing three entries that made the
difference.  Thanks for identifying them for me.

The triggers work properly in both server now.

--
Justin Kennedy
Systems Analyst I


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: multi line text data/query ?bug?
Next
From: Richard Huxton
Date:
Subject: Re: PHP SQL