From: | "Thomas H(dot)" <me(at)alternize(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3767: tsearch2 index creation fatal crash |
Date: | 2007-11-21 02:54:23 |
Message-ID: | 47439DDF.5010600@alternize.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-docs |
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-21 03:40:43 | Re: BUG #3766: tsearch2 index creation error |
Previous Message | Tom Lane | 2007-11-21 02:48:46 | Re: BUG #3767: tsearch2 index creation fatal crash |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-21 03:45:25 | Re: BUG #3767: tsearch2 index creation fatal crash |
Previous Message | Tom Lane | 2007-11-21 02:48:46 | Re: BUG #3767: tsearch2 index creation fatal crash |