Skip site navigation (1) Skip section navigation (2)

BUG #3766: tsearch2 index creation error

From: "Thomas Haegi" <me(at)alternize(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3766: tsearch2 index creation error
Date: 2007-11-21 02:22:58
Message-ID: 200711210222.lAL2MwUm063310@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3766
Logged by:          Thomas Haegi
Email address:      me(at)alternize(dot)com
PostgreSQL version: 8.3b3
Operating system:   Windows 2003
Description:        tsearch2 index creation error
Details: 

when following the documentation
(http://www.postgresql.org/docs/8.3/static/textsearch-tables.html), the
creation of an gin tsearch index fails:

CREATE INDEX posts_fts_idx ON forum.posts USING gin(to_tsvector('english',
p_msg_clean));

ERROR:  translation from wchar_t to server encoding failed: No error

********** Error **********

ERROR: translation from wchar_t to server encoding failed: No error
SQL state: 22021



field p_msg_clean is TEXT (unlimited), db encoding is UTF8.

- thomas

Responses

pgsql-bugs by date

Next:From: Thomas HaegiDate: 2007-11-21 02:25:14
Subject: BUG #3767: tsearch2 index creation fatal crash
Previous:From: Kevin GrittnerDate: 2007-11-20 22:28:23
Subject: Re: BUG #3765: strange results for bit string hexnotation cast to bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group