Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jKD4u-0004LL-D3 for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Apr 2020 03:33:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jKD4t-0007VX-9H for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Apr 2020 03:33:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jKD4t-0007TJ-33 for pgsql-bugs@lists.postgresql.org; Fri, 03 Apr 2020 03:33:07 +0000 Received: from mail-pf1-x444.google.com ([2607:f8b0:4864:20::444]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jKD4q-0006jC-Kb for pgsql-bugs@lists.postgresql.org; Fri, 03 Apr 2020 03:33:06 +0000 Received: by mail-pf1-x444.google.com with SMTP id f206so2808464pfa.10 for ; Thu, 02 Apr 2020 20:33:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=NO7mBXoEa+LU5JhCA93Vto2mrK1DBgY0tm0fTEuxAkg=; b=L6ZiG0vprpISOolJgZt69XowWr/ddDumAV5OFFTrIgqV+bWtj6/TwtSLTvwEY7qCi1 LtL90U8rNizp0OU6rWmJkEyxqv8CNgnzpFw0SxeK7kZm1pI8YBJePvJPuHzzzCv8YEs5 eK+CmlzxlOCdnpOoGf+UMFgKVYO7hq1x1Ab/hF2at/eRAPmjAzf8MIUeZdku0L2SRCfk AD9m9dWbqYK94FSVsbuPMtB1kroEDJevq7RMnWwpa9JnHOOAbFd9sFk3vl8Ti0Dg9gVF z0n8mP/ZmmnidB+tlv1sm5vkS3TkuobVo+lm/9VXq+/x8e5Z1hBDtU2vG+859OtotGPx 1HCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=NO7mBXoEa+LU5JhCA93Vto2mrK1DBgY0tm0fTEuxAkg=; b=CoRyBT0IkgO/T5J52yDdAOeZaVS2OjxzurkrFfVn4LkTVUhmUNUrR/Yc36z8EPrU3/ Xj51+FKMb6n2Hj4AoOTTkg4KhSgZSdM9nqJX87UgOeEjYOxRmHlkqRQ5EMOJO/JOnBqj /pGM2ziqUAUnOGDpwBQabmbwF3Dmuc2BwiOee8g993KUo6xP8I1F3fdAblE7Naa4T89S zRUCgd14aVbaz/gCpB7gGrk9TCDyphlNp/RLmTvQC21Q+ocd+xXuhbjiWMcKLnqWPFbL QiQLJfViiin3WICC5cl9AWtzDBELtCFkP1SWPEQrXEWRfIjcBRiWnOX9doC3CdirkDj9 75/Q== X-Gm-Message-State: AGi0PuZtMfbaHmQ55bOn7f+m4bYQ5vewTUo8vK/VaOgbq4HvUpvg60jF IucSdD0dn1/qd1njhRNy0f0= X-Google-Smtp-Source: APiQypLw96Z88+RVNPHC6xKjxPvxcHS0QVI1Le2bzdyMNEFR526mHvgnXRgsMVDgj0q0dfRaxluWOg== X-Received: by 2002:a05:6a00:2d1:: with SMTP id b17mr6516116pft.210.1585884783455; Thu, 02 Apr 2020 20:33:03 -0700 (PDT) Received: from [192.168.2.111] (113x32x180x194.ap113.ftth.ucom.ne.jp. [113.32.180.194]) by smtp.gmail.com with ESMTPSA id u4sm4265479pgu.5.2020.04.02.20.33.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Apr 2020 20:33:02 -0700 (PDT) Subject: Re: BUG #16337: Finnish Ispell dictionary cannot be created To: matti.linnanvuori@portalify.com, pgsql-bugs@lists.postgresql.org, PG Bug reporting form References: <16337-0a68a7a1726ffbc6@postgresql.org> From: Artur Zakirov Message-ID: Date: Fri, 3 Apr 2020 12:33:00 +0900 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Thunderbird/68.6.0 MIME-Version: 1.0 In-Reply-To: <16337-0a68a7a1726ffbc6@postgresql.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, On 4/2/2020 7:11 PM, PG Bug reporting form wrote: > postgres=# CREATE TEXT SEARCH DICTIONARY finnish_ispell ( TEMPLATE = ispell, > DictFile = fi_fi, AffFile = fi_fi, Stopwords = finnish); > ERROR: syntax error > CONTEXT: line 83 of configuration file > "/usr/pgsql-12/share/tsearch_data/fi_fi.affix": " I > > ALI\- > " Thank you for the email. It seems that here the backslash is used to escape the following character according to the comment for the following flag: > flag *E: > . > YLI # ylijohtaja > I > YLI\- # yli-inhimillinen Escaping character is valid for ispell format (see https://manpages.debian.org/testing/ispell/ispell.5.en.html): > Any character with special meaning to the parser can be changed to an uninterpreted token by backslashing it I've looked also for Hunspell finnish dictionary. But I didn't find any I found only some postgres extension: https://github.com/Houston-Inc/dict_voikko I think it is possible to fix the postgres parser. But I'm not sure should we do that. At first sight it is necessary to fix parse_affentry(). -- Artur