Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQ1Aq-0006if-P7 for pgsql-translators@arkaria.postgresql.org; Wed, 20 Jul 2016 23:45:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQ1Aq-00011M-7y for pgsql-translators@arkaria.postgresql.org; Wed, 20 Jul 2016 23:45:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQ1Ap-0000za-Ut for pgsql-translators@postgresql.org; Wed, 20 Jul 2016 23:45:08 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQ1Am-0006AW-Pa for pgsql-translators@postgresql.org; Wed, 20 Jul 2016 23:45:06 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id E8BD0202C9; Wed, 20 Jul 2016 19:45:03 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute2.internal (MEProxy); Wed, 20 Jul 2016 19:45:03 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=iYNnsuZnFF/m0YV ET4eDxwydYFc=; b=uFkAuPGDqdFJ5UlZt11MzRDlM4Pigzbrc5NoSSWXwcMNykd fNh7vwGYApbGAFtZ4x2I8+ja0uRAzXekuNp+kwFc+u7Uza6Sfel1+g1A2EQ6gN+U dyWWpf+pshFgKekBKRRtU4pgUd9E3TyWGD6KsGZHB2dR6qNa4nQoTX9Rso/I= X-Sasl-enc: ZKU7Mg+VtAK64knVwuveu4mfnDGCsPEqw2G/IA9hU6Gv 1469058303 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id A75EFF29EE; Wed, 20 Jul 2016 19:45:03 -0400 (EDT) Subject: Re: Problem with error messages To: Alexander Law , pgsql-translators@postgresql.org References: <337ce77f-4159-0f43-cdb7-fcac30e3e219@2ndquadrant.com> <578F1B63.5000301@gmail.com> Cc: Walter Willmertinger From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <2177748d-ff90-535c-080c-5ee0f399f4af@2ndquadrant.com> Date: Wed, 20 Jul 2016 19:45:02 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: <578F1B63.5000301@gmail.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-translators Precedence: bulk Sender: pgsql-translators-owner@postgresql.org On 7/20/16 2:34 AM, Alexander Law wrote: > I think we shouldn't leave them with the untranslated messages, instead > we just should TRANSLIT option of iconv. > For example: > >>echo 'HINWEIS: Tabelle »mickeymouse« existiert nicht, wird übersprungen' | iconv -f UTF-8 -t ASCII > HINWEIS: Tabelle iconv: illegal input sequence at position 17 > > But > >>echo 'HINWEIS: Tabelle »mickeymouse« existiert nicht, wird übersprungen' | iconv -f UTF-8 -t ASCII//TRANSLIT > HINWEIS: Tabelle >>mickeymouse<< existiert nicht, wird ubersprungen > > Is much better and still better than to show untranslated message with > the notice about failed conversion. Right, but we don't have that functionality in PostgreSQL. It would have to be implemented, and the transliteration tables provided. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-translators mailing list (pgsql-translators@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-translators