the reported problem below can be reproduced by using this simple query
straight from the documentation:
SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');
Works for me:
u=# set default_text_search_config = 'pg_catalog.german';
SET
u=# SELECT to_tsvector('a fat cat sat on a mat and ate a fat rat');
to_tsvector
-------------------------------------------------------------------------------
'a':1,6,10 'on':5 'and':8 'ate':9 'cat':3 'fat':2,11 'mat':7 'rat':12 'sat':4
(1 row)
even when implicitly setting default_text_search_config before the query
as you did, it fails (but gives a slightly different error message):
ERROR: translation from wchar_t to server encoding failed: No such file
or directory
maybe win32 / file paths related?
there are more problems with tsvectors. this also fails:
SELECT ' just a test: 123 '::tsvector;
ERROR: syntax error in tsvector: " just a test: 123 "
********** Error **********
ERROR: syntax error in tsvector: " just a test: 123 "
SQL state: 42601
without ":" it works:
SELECT ' just a test 123 '::tsvector;
regards, thomas
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend