Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 12 Dec 2025 10:14:48 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?iso-8859-1?Q?=C1lvaro?= Herrera <alvherre@kurilemu.de>
Cc: Guillaume Lelarge <guillaume.lelarge@dalibo.com>,
	pgsql-translators@lists.postgresql.org
Subject: Re: requiring all .po files be UTF8-encoded
Message-ID: <aTtsiIXWLKvt5V_F@paquier.xyz>
References: <aToNMMKLZRGLCzWg@paquier.xyz>
 <202512110644.isp62d245zcm@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="L5YIqxaIbCx3Nv2r"
Content-Disposition: inline
In-Reply-To: <202512110644.isp62d245zcm@alvherre.pgsql>
Archived-At: 
 <https://www.postgresql.org/message-id/aTtsiIXWLKvt5V_F%40paquier.xyz>
Precedence: bulk


--L5YIqxaIbCx3Nv2r
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 11, 2025 at 07:51:33AM +0100, Alvaro Herrera wrote:
> postgres.po has 6411 strings.  The French translation is currently at
> 78%, and msgfmt says:
>=20
> 5096 translated messages, 988 fuzzy translations, 327 untranslated messag=
es.
>=20
> My impression is that the postgres.po catalog drops about 8%-10% for
> each major release.

Okay, I am new to this business, still I can see what Guillaume has
been doing in the repo for these things in the fr translation, which
is pgtranslation/messages.git, with master pointing to upstream
REL_18_STABLE, I guess.

I am also guessing that most folks just rely on something like po-mode
on emacs, which is available here:
https://manpage.me/docs/sharedocs/gettext/gettext_8.html

I have quickly tested it and that feels natural, I am not used to the
shortcuts yet but the docs are pretty clear.

I have a couple of stupid questions.  What's the flow of a translation
refresh?  Are the files first generated from the top of a stable
branch in the main Postgres repository using `make update-po` on a
periodic basis, then copied back to the translation repository for
further edits (line number updates, etc.)?  Is it more common to edit
the existing files in place, without pulling them from the main
repository?

Guillaume, I am likely not going to get that right in the first shot.
Would you mind reviewing some of the stuff?  Would it be OK to just
send a patch on this list?  If you have a po file that could serve as
a good first example, feel free to offer a suggestion or I would just
pick up one.  Say only for a couple of entries to get the full idea of
how things work.
--
Michael

--L5YIqxaIbCx3Nv2r
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmk7bIgACgkQnvQgOdby
QH3EXQ//VFMG3j4q/KbSJIsiVGQGo/8E7PfqmzPUAlt7wtq5BS7j1rPCLv30zRNL
tKEmrEHC94hMnqwr5flB5OYsQhpJJbURON1zX4mfdDEMOkezN0hfuXb26birqP+Z
mQp3yusHz/06uXfC/Fl93cKXl/adOLC4CHlTjrRgKPU2Ekx8hq0zLuG9i9UMmReY
uwOA/8RySwv30Xdab3FoMpvQ1NkzYND30VTIb91ROZ5XbTpwX29nrREf4RVpo2Ym
+0d5jfdOGhX1O6uIIkAsg7P2vzk3GMl7Woi2819BNCDIzSsxyZMTAHl3d4hjcIxp
klmmIm8rWt9YUBX70Oc9tA06oeRbxTBdduKNpnZHkhYftBxosyFowzWf+w2Z3eR9
4xCpku3V49qty817ARdUpWxL4P7VgUpDNS7wQcISBEVVkR0aFOPfYgZweGO3q6xa
FhcNEsvm2vcHLJUJy5OcwhgfP4yTq/hwcTdAQ1lYyaCNSgm+8LC0jQnyBm6pEi4I
5VNBhwtH50apDZ6VcjCW3WSaPAHbcuUeoP58ZzlE46jFCPYzcSIRYRQVP4xn96RD
F4ZBMsJ3r80xah28VD0bCCStTPxp8VrKVwwKu1xfv5lDC+T0ruA2Opgqas5VA3s1
2xc2KAhFPgiVKsll09UeC92wIfy/nftGOwgXXJlHNpwPRb7uTxY=
=GDwC
-----END PGP SIGNATURE-----

--L5YIqxaIbCx3Nv2r--