Re: quoteOneName() inconsistency with quote_all_identifiers — replacement API proposed

From: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: quoteOneName() inconsistency with quote_all_identifiers — replacement API proposed
Date: 2025-11-21 05:52:04
Message-ID: CAEoWx2nPbikvjp0JBsHzbpE=u7aMkiVy-WCmPim2iX5hDF9fBw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Nov 20, 2025 at 8:28 PM Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:

> Hi,
>
> > - appendStringInfo(&buffer, _("text search configuration
> %s"),
> > - quote_qualified_identifier(nspname,
> > -
> NameStr(cfgForm->cfgname)));
> > + appendStringInfoQualifiedIdentifier(&buffer,
> > + _("text search
> configuration "),
> > + nspname,
> NameStr(cfgForm->cfgname), NULL);
> > ReleaseSysCache(tup);
> > break;
> > }
>
> This doesn't work from a i18n point of view. In the original
> formulation, the translator is free to place the %s wherever it suits
> the language. In the new one there's no such freedom: the name will be
> appended at the end. Some existing translations:
>
> ko.po:msgid "text search configuration %s"
> ko.po-msgstr "%s 전문 검색 구성"
>
> tr.po:msgid "text search configuration %s"
> tr.po-msgstr "%s metin arama yapılandırması"
>

Thanks for the feedback. I reverted that piece of change in v3.

Best regards,
Chao Li (Evan)
---------------------
HighGo Software Co., Ltd.
https://www.highgo.com/

Attachment Content-Type Size
v3-0001-Add-appendStringInfoIdentifier-to-avoid-intermedi.patch application/octet-stream 10.8 KB
v3-0003-Remove-quoteOneName-and-related-buffer-sizing-mac.patch application/octet-stream 11.5 KB
v3-0004-Use-appendStringInfoIdentifier-in-more-places.patch application/octet-stream 35.6 KB
v3-0002-Use-appendStringInfoIdentifier-throughout-ri_trig.patch application/octet-stream 21.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-11-21 05:57:08 Re: Row pattern recognition
Previous Message Yuefei Shi 2025-11-21 05:33:56 Re: Extended Statistics set/restore/clear functions.