BUG #7780: unaccent extension - dictionary not filtering? - Mailing list pgsql-bugs

From giorgio.gallo@bitnic.it
Subject BUG #7780: unaccent extension - dictionary not filtering?
Date
Msg-id E1TqA1B-0000s1-Uc@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7780
Logged by:          Giorgio Gallo
Email address:      giorgio.gallo@bitnic.it
PostgreSQL version: 9.1.7
Operating system:   OSX
Description:        =


Ciao

I'm working to set up full-text search and I enabled the "unaccent"
extension.
The "unaccent" dictionary however does not seem to behave as a filtering
dict, but rather as a "normal" one...
Am I doing anything wrong or is this in fact a postgres issue?


Version:

PostgreSQL 9.1.7 on x86_64-apple-darwin, compiled by
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3),
64-bit

Test script:

create extension if not exists "unaccent";
create text search configuration TEST_TSCFG (parser =3D DEFAULT);
alter text search configuration TEST_TSCFG alter mapping for asciiword, word
with UNACCENT, ITALIAN_STEM;
select * from ts_debug('TEST_TSCFG','H=C3=B4TeL HoTeL');
drop text search configuration if exists TEST_TSCFG;
drop extension if exists "unaccent" restrict;

Output:

   alias   |    description    | token |      dictionaries       | =

dictionary  | lexemes =

-----------+-------------------+-------+-------------------------+---------=
-----+---------
 word      | Word, all letters | H=C3=B4TeL | {unaccent,italian_stem} | una=
ccent =

   | {HoTeL}
 blank     | Space symbols     |       | {}                      |          =

   | =

 asciiword | Word, all ASCII   | HoTeL | {unaccent,italian_stem} |
italian_stem | {hotel}

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #7767: pg_ctl allows postgres running under administrator's privilege
Next
From: "Sell, Kenneth"
Date:
Subject: Re: Database crash in Postgres 8.4.3