Thread: share directory on windows
Hello, I wanted to install text search dictionaries on Windows 8.4 installation with the following command: CREATE TEXT SEARCH DICTIONARY skspell (template=ispell, dictfile = slovak_utf8, afffile=slovak_utf8, stopwords=slovak_utf8); but got this error: ERROR: could not open dictionary file "/usr/share/postgresql/8.4/tsearch_data/slovak_utf8.dict": No such file or directory SQL state: F0000 The file is located in c:\Program Files\PostgreSQL\8.4\share\tsearch_data\slovak_utf8.dict. Is this an incorrect location?Where is the correct location or how to point the database to look in my current location? Thanks in advance, Viliam
=?UTF-8?B?VmlsaWFtIMSOdXJpbmE=?= <viliam.durina@kios.sk> writes: > I wanted to install text search dictionaries on Windows 8.4 installation with the following command: > CREATE TEXT SEARCH DICTIONARY skspell > (template=ispell, dictfile = slovak_utf8, afffile=slovak_utf8, stopwords=slovak_utf8); > but got this error: > ERROR: could not open dictionary file "/usr/share/postgresql/8.4/tsearch_data/slovak_utf8.dict": No such file or directory That's pretty bizarre. Did you move the postgres executable relative to the tsearch_data files? It looks like you could get a hard-wired path if you moved the executable out of its intended place. It's still not too clear to me why you got *that* hard-wired path though; I'd have expected the built-in value to be something different from that in a Windows build. Whose build are you using? regards, tom lane
Sorry, my fault, I copied the dictionary files to my local windows installation, but was connected to our linux installation.Connecting to the right server resolves the problem :) Viliam On 22.3.2011 16:03, Tom Lane wrote: > =?UTF-8?B?VmlsaWFtIMSOdXJpbmE=?=<viliam.durina@kios.sk> writes: >> I wanted to install text search dictionaries on Windows 8.4 installation with the following command: > >> CREATE TEXT SEARCH DICTIONARY skspell >> (template=ispell, dictfile = slovak_utf8, afffile=slovak_utf8, stopwords=slovak_utf8); > >> but got this error: >> ERROR: could not open dictionary file "/usr/share/postgresql/8.4/tsearch_data/slovak_utf8.dict": No such file or directory > > That's pretty bizarre. Did you move the postgres executable relative to > the tsearch_data files? It looks like you could get a hard-wired path > if you moved the executable out of its intended place. It's still not > too clear to me why you got *that* hard-wired path though; I'd have > expected the built-in value to be something different from that in a > Windows build. Whose build are you using? > > regards, tom lane