Message-ID: <47439DDF.5010600@alternize.com>
Date: Wed, 21 Nov 2007 03:54:23 +0100
From: "Thomas H." <me@alternize.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@postgresql.org
Subject: Re: BUG #3767: tsearch2 index creation fatal crash
References: <200711210225.lAL2PE8a064911@wwwmaster.postgresql.org>
	<47439A13.3000404@alternize.com> <21708.1195613326@sss.pgh.pa.us>
In-Reply-To: <21708.1195613326@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

>> 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