The following bug has been logged online: Bug reference: 3766 Logged by: Thomas Haegi Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend