Date: Wed, 15 May 2019 23:51:12 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Ioseph Kim <pgsql-kr@postgresql.kr>
Cc: pgsql-translators@lists.postgresql.org,
	Turkish <ceviri@postgresql.org.tr>, Yuwei Peng <ywpeng@whu.edu.cn>
Subject: Re: inconsistent translations, or the language is like that?
Message-ID: <20190516035112.GA27177@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <17734d60-3519-0895-2d27-658f3496ac9f@postgresql.kr>
User-Agent: Mutt/1.9.4 (2018-02-28)
Precedence: bulk

On 2019-May-16, Ioseph Kim wrote:

Hi, thanks for replying so quickly.

> The exact Korean expression is 'INSERT RETURNING 구문을 수행할 수 없음'.
> 
> perform has same meaming for '구성' and '수행'.
> 
> and '없음' is abbreviated to '없습니다'.

I see :-)

> I'll change it in the next version. thanks.
> 
> I am more curious why you are interested in this matter. :)

Well, I'm considering changing the way those three error messages are
emitted by the server, so that the three cases use the same code.  So
the translator would only get this string in the translation file:

 "cannot perform %s on relation \"%s\""

instead of getting three strings.  Then the program would substitute the
first %s by INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING
depending on which case is hit.

So I was searching for occurrences of those three messages in the
existing translations, looking for any where the three translations
were not identical, and Korean was the first I found.

After sending, I realized that the translations for simplified Chinese and
Turkish of the three phrases are also different!

simplified Chinese:

msgstr "无法在关系\"%s\"上执行INSERT RETURNING "
msgstr "无法在关系\"%s\"执行UPDATE RETURNING"
msgstr "无法在关系 \"%s\"上执行DELETE RETURNING"

Turkish:

msgstr "\"%s\" nesnesinde INSERT RETURNING yapılamaz"
msgstr "\"%s\" nesnesinde UPDATE RETURNING yapılamaz"
msgstr "\"%s\" nesnesi üzerinde DELETE RETURNING işlemi yapılamaz"


I don't speak (or even read) either of these languages so can't tell
whether the translations are just different because there are two ways
of writing the same thing (so my proposed change would not cause a
problem), or the languages have inflection or grammatical rules that
make the phrases be different (which makes my proposed change not
acceptable).

My preliminary conclusion is that I shouldn't be changing this.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services