From: Thomas H. <me@alternize.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-bugs@postgresql.org
Subject: Re: BUG #3767: tsearch2 index creation fatal crash
Date: Wed, 21 Nov 2007 03:54:23 +0100
Message-ID: <47439DDF.5010600@alternize.com> (raw)
In-Reply-To: <21708.1195613326@sss.pgh.pa.us>
References: <200711210225.lAL2PE8a064911@wwwmaster.postgresql.org>
<47439A13.3000404@alternize.com>
<21708.1195613326@sss.pgh.pa.us>
>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: me@alternize.com, tgl@sss.pgh.pa.us, pgsql-bugs@postgresql.org
Subject: Re: BUG #3767: tsearch2 index creation fatal crash
In-Reply-To: <47439DDF.5010600@alternize.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox