The following bug has been logged online:
Bug reference: 3766
Logged by: Thomas Haegi
Email address: me@alternize.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