Bug 1006703 - Cannot install custom ispell dictionaries to postgres
Summary: Cannot install custom ispell dictionaries to postgres
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: OpenShift Online
Classification: Red Hat
Component: Containers
Version: 2.x
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: Michal Fojtik
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-11 07:09 UTC by Michal Moravec
Modified: 2019-05-20 11:05 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-10-28 23:51:49 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Michal Moravec 2013-09-11 07:09:27 UTC
Description of problem:

I'm trying to install custom dictionary for my language (czech) from ispell to postgres 9.2 into my application.

I've setup port forwarding of the app and executed following code via pgAdmin:

CREATE TEXT SEARCH DICTIONARY czech (
    TEMPLATE = ispell,
    DictFile = czech,
    AffFile = czech,
    StopWords = czech
);

But got an error:

 ERROR: could not open dictionary file "/opt/rh/postgresql92/root/usr/share/pgsql/tsearch_data/czech.dict": No such file or directory

I don't have access to that directory, so the dictionary cannot be loaded from there. Specifying absolute path does not work. It seems that its not allowed by postgres.

I can execute that on my dev machine, but not on Openshift.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.

CREATE TEXT SEARCH DICTIONARY czech (
    TEMPLATE = ispell,
    DictFile = czech,
    AffFile = czech,
    StopWords = czech
);

Actual results:

 ERROR: could not open dictionary file "/opt/rh/postgresql92/root/usr/share/pgsql/tsearch_data/czech.dict": No such file or directory

Expected results:


Additional info:

Comment 1 Andy Grimm 2013-09-11 13:32:00 UTC
My understanding is that postgresql does not include these files in its source tree, and you must retrieve them from some other source.  It does not appear that there's a way for a user without access to /opt/rh/postgresql92/root/usr/share/pgsql to add dictionaries (and this is a compile-time option, so we can't fix it with symlinks).

Comment 3 Michal Fojtik 2013-09-12 09:42:53 UTC
Eventually you can modify the postgresql cartridge and add that file manually.

Comment 4 Jhon Honce 2013-10-28 23:51:49 UTC
Follow status of enhancement here: https://trello.com/c/8edB9ciz


Note You need to log in before you can comment on or make changes to this bug.