From: | "Melek JARRAYA" <MJARRAYA(at)cfirst(dot)fr> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Not found indexed word |
Date: | 2018-08-31 06:36:56 |
Message-ID: | OF0ABA6683.0920B4D8-ONC12582FA.002455EF-C12582FA.00245761@abw.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
By Défault the application is in French, but also i have the opportunity to
change in English or German.Can this cause the problem ?
If yes you must have serval words that do not go back in the search but in
this case there is just the set of words (pepinier , pepini, pepini, pepin,
pepi , pep), that does not go back.
Best regards,
Cordialement,
JARRAYA Melek
Tel: 03 88 06 64 34
De : Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
A : "Melek JARRAYA" <MJARRAYA(at)cfirst(dot)fr>
Cc : Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Pg Bugs
<pgsql-bugs(at)postgresql(dot)org>
Date : 23/08/2018 16:43
Objet : Re: Not found indexed word
"Melek JARRAYA" <MJARRAYA(at)cfirst(dot)fr> writes:
> Here is in screenshot the query executed for the search for the word
> "Pepinier".
> The search result is always null.
> QueryWords contains the search word.
You seem to be using the single-argument form of to_tsquery, which
means that the way it stems the word is going to depend on the
setting of default_text_search_config. It looks like the stored
word was stemmed using the "french" setting, but maybe that's not
what prevails for your running application. I'd try executing
just "SELECT to_tsquery('Pepiniere')" from your application and
see what you get.
In some quick experiments here, I get 'pepinier' in French or
Spanish, but just 'pepini' in English or German. So that'd be
enough to prevent a match to a stored 'pepinier'.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2018-08-31 09:51:00 | Re: BUG #15352: postgresql FDW error "ERROR: ORDER BY position 0 is not in select list" |
Previous Message | Ashutosh Bapat | 2018-08-31 06:28:26 | Re: BUG #15352: postgresql FDW error "ERROR: ORDER BY position 0 is not in select list" |