X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CA2949FA2FA for ; Wed, 24 May 2006 10:23:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76274-03 for ; Wed, 24 May 2006 10:23:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 1D16D9F9F8F for ; Wed, 24 May 2006 10:22:59 -0300 (ADT) Received: (qmail 6016 invoked by uid 0); 24 May 2006 13:22:57 -0000 Received: 192.54.122.9 by service.gmx.net with HTTP; Wed, 24 May 2006 15:22:57 +0200 (CEST) X-Flags: 0001 Message-ID: <20060524132257.198070@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 24 May 2006 15:22:57 +0200 from: Raphael Bolfing Subject: tsearch2 (ERROR: Affix parse error at 448 line) to: pgsql-admin@postgresql.org X-Authenticated: #3157654 X-Mailer: WWW-Mail 6100 (Global Message Exchange) x-priority: 3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/336 X-Sequence-Number: 21868 Hi, I have installed postgresql 8.1.3 on a SuSE9.3 with tsearch2.82. Tsearch2.82 supports UTF-8 Encoding!! At first i was fighting with a utf-8 problem: invalid utf-8 byte sequence The Problem was the german.aff and german.med Files. These Files weren't encoding for utf-8. I did it with recode from iso-8859-1 to UTF-8 Ive tested with a guide from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ GUIDE: Tsearch2 and Unicode/UTF-8 by Markus Wollny Ive had the Problem @ the Point IV. Configuration of tsearch2 ive downloaded de dictionaries tsearch2_german_utf8.zip and @ this command: select set_curdict('de_ispell'); Result is this Error: ERROR: Affix parse error at 448 line Ive got the same Error at the tsearch2 functionality test: e.g. select * ts_debug('only a test'); Can anyone help? Or knows anyone who can help? THX for the time.. Raphi -- Bis zu 70% Ihrer Onlinekosten sparen: GMX SmartSurfer! Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer