From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: pperalta@gmail.com
Subject: BUG #18149: Incorrect lexeme for english token "proxy"
Date: Thu, 05 Oct 2023 21:44:27 +0000
Message-ID: <18149-936d14e6fc76ca61@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18149
Logged by: Patrick Peralta
Email address: pperalta@gmail.com
PostgreSQL version: 14.5
Operating system: Linux
Description:
The english dictionary is using the lexeme "proxi" for the token "proxy". As
a result, the search term "proxy" is not yielding results for records that
contain this word.
# select * from ts_debug('english', 'proxy');
alias | description | token | dictionaries | dictionary |
lexemes
-----------+-----------------+-------+----------------+--------------+---------
asciiword | Word, all ASCII | proxy | {english_stem} | english_stem |
{proxi}
I think this lexeme was chosen to support the plural of proxy which is
proxies. However there are other plurals where the root word is spelled
different and Postgres creates the correct lexeme such as:
# select * from ts_debug('english', 'goose');
alias | description | token | dictionaries | dictionary |
lexemes
-----------+-----------------+-------+----------------+--------------+---------
asciiword | Word, all ASCII | goose | {english_stem} | english_stem |
{goos}
# select * from ts_debug('english', 'mouse');
alias | description | token | dictionaries | dictionary |
lexemes
-----------+-----------------+-------+----------------+--------------+---------
asciiword | Word, all ASCII | mouse | {english_stem} | english_stem |
{mous}
I believe we can create our own dictionary as a workaround
(https://www.postgresql.org/docs/current/textsearch-dictionaries.html) but
I'm reporting this to see if using "proxi" for "proxy" is intentional.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, pperalta@gmail.com
Subject: Re: BUG #18149: Incorrect lexeme for english token "proxy"
In-Reply-To: <18149-936d14e6fc76ca61@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox