Your message dated Tue, 20 May 2025 14:28:28 -0700
with message-id <6156399.lOV4Wx5bFT@soren-desktop>
and subject line Myspell-nl files can't be loaded in a PostgreSQL dictionary
has caused the Debian Bug report #766634,
regarding Myspell-nl files can't be loaded in a PostgreSQL dictionary
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
766634: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=766634
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: myspell-nl
Version: 1:2.10-1
Debian version: 7.6
The problem is that the file /usr/share/hunspell/nl.aff (part of the
myspell-nl package) gives errors if you construct a ispell Dictionary with
it in PostgreSQL as follow:
CREATE TEXT SEARCH DICTIONARY dutch_ispell (
template = ispell,
DictFile = nl,
AffFile = nl,
StopWords = dutch
);
The error reads:
ERROR: wrong affix file format for flag
CONTEXT: line 827 of configuration file
"/usr/share/postgresql/9.3/tsearch_data/nl.affix": "SFX CA Y 2"
In the /usr/share/hunspell/nl.aff file it says:
# accept an optional - when compounding, first part
# the second line allows for the optional hyphen
SFX CA Y 2
SFX CA 0 /CaCp
SFX CA 0 -/CaCp
In the PostgreSQL documentation it reads (
<http://www.postgresql.org/docs/8.3/static/textsearch-dictionaries.html#TEXT
SEARCH-ISPELL-DICTIONARY>
http://www.postgresql.org/docs/8.3/static/textsearch-dictionaries.html#TEXTS
EARCH-ISPELL-DICTIONARY):
Note: MySpell does not support compound words. Hunspell has sophisticated
support for compound words. At present, PostgreSQL implements only the basic
compound word operations of Hunspell.
So the problems are:
- The package Myspell-nl appears to deliver a Hunspell dictionary (there is
not even a simlink in the /usr/share/myspell/dits/ directory, there are
simlinks there for the Hunspell files installed through the Hunspell-en and
Hunspell-de packages)
- PostgreSQL does not support COMPOUND words in Hunspell files (or at least
not the way it is done in the Dutch affix file)
- Since I only know this error to appear in PostgreSQL when using the Dutch
myspell files I don't know where to report this, the myspell-nl package or
the PostgreSQL-common package. The PostgreSQL-common package comes with the
"pg_updatedicts" this automatically copies supported installed files to
/var/cache/postgresql/dicts/ and creates links to them in
/usr/share/postgresql/9.3/tsearch_data. The myspell-nl puts the files in a
place where pg_updatedicts expects them to be compatible with PostgreSQL.
Hope it helps
--- End Message ---
--- Begin Message ---
Dutch no longer ships a binary package named myspell-nl. But your assessment
is correct that for a period of time it did ship that package containing a
Hunspell dictionary. Some time after you filed this bug, the name of the
binary package was changed from myspell-nl to hunspell-nl.
There is a Dutch wordlist installed by the wdutch package, which might be what
you are looking for.
--
Soren Stoutner
so...@debian.org
signature.asc
Description: This is a digitally signed message part.
--- End Message ---
