Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vpkxU-00FE3c-2r for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Feb 2026 10:27:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpkxS-00F2rH-37 for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Feb 2026 10:27:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vpkxS-00F2r8-28 for pgsql-hackers@lists.postgresql.org; Tue, 10 Feb 2026 10:27:02 +0000 Received: from fout-b3-smtp.messagingengine.com ([202.12.124.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vpkxQ-00000001yTB-0bvj for pgsql-hackers@lists.postgresql.org; Tue, 10 Feb 2026 10:27:02 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id B5E6B1D00144; Tue, 10 Feb 2026 05:26:57 -0500 (EST) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Tue, 10 Feb 2026 05:26:57 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1770719217; x= 1770805617; bh=r+ramh6U/mFcbxeyBm9FvOZC3t2FXWQRDa4M8MhRTG0=; b=U 2Ro0koDFSWiSExJO4vLGg2DSiAgHtkLP+6jniZZiHbjI4bX0b5mmtIBC+0rFcRSi 8Jm4K7Ob1WdgrmAev64nMQQR6kg2LKKXB0NG+m7fNtYR3S8W2zuklgu9axZ7pUG5 6pxeLHUyLybUIY8/Kx7/1Yn7jIefJWuehb+uGQzxGcWc9nadGH5OGaz06V+iX8Ia MDhfGJkcIo5QuTcLEXEPRBlr8QuY0ylmwR5+KHBxnv+jMnufkzFkbWRKJogQFG6z DAwsGPBYvBLrU0EHdxK6Tg0zjKTCOI4oiyUx9+gDp6Yo1QtorncWTWs1K3eEp3qu 1Dg3YvXzMQy7UXS4XpAgQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1770719217; x=1770805617; bh=r +ramh6U/mFcbxeyBm9FvOZC3t2FXWQRDa4M8MhRTG0=; b=NHA7gM2ZXjUbCf+X8 jvLeKzVLfuXjG/db1Ox4i6ZL5agX7gYQe2+lA1DyaFkUamfXib8gY8Tk597eMwUA hBjaLa8nrj0pZgrTmI3hHeDaGWPPtd2G6mU4RYETWJ3TQPLtabld2eymztJL0mbl BVnyApsHTBu2kPQlL0fHV0jqhHhbpkUu5TZbOSZxX+aWcceqHi8ifIE49knTrOrW 99br15q2SLklGdIKhC05ZwQGBaOLksHnLr4aF7E8IuK57+QcxEeCWphMfjpTsjvW /bs3kTxrzzdV5PnFAMq3TZsXdtUjzBO5ON2Vviy5yCJM3m+Z9JkZzl26nRM+qFoT 5U4/A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdduleelgeefucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfggtggugfgjsehtkeertd dttdejnecuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgeqnecuggftrfgrthhtvghrnhepteeuvdehffekvefgueehve etveekgfegtddtueefueehuddutdfhfeffhfejfeffnecuffhomhgrihhnpegvnhhtvghr phhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghp thhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohephhhorhhikhihohhtrg drnhhtthesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhs sehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 10 Feb 2026 05:26:56 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1770719215; bh=XhfFNZ7wKtUOW7hx1z53xLxGR61LfNQcSQVh4/wMdYk=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=Zr5BFa0iraEGXJZRwhpjIe/M/Cbv2DatdQZC/HyOS6e3JNtDZPRrIvCCuAZ9pg9/7 coXH5rLvwc07BOaJqum3RtxPKrahPNzdnNjjJypT3daJAoPuKoC2n0hmriwz1w6nj9 huaGydxQblcF6HHu5t6D/yzyQkiyNRUpFBiw9caVcPoQTWevAQDQku5jICyVSsFJqP dpQN7BlKb40cqPxmbTTE9F96mKoeuUe3sjpDGwsZlOch/ZPa2l6aUm//JHankh4xi0 +A7AzGW0utm9ebvDSVHwwL+cMd1SF9UsdF/R79uJhwUYJNNzwMgL6Jm/fKJVaKaz/8 STvrmboTSs8bw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id AA9807A; Tue, 10 Feb 2026 11:26:55 +0100 (CET) Date: Tue, 10 Feb 2026 11:26:55 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Kyotaro Horiguchi Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Miscellaneous message fixes Message-ID: <202602101023.p75nm75pl7jh@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20260210.143752.1113524465620875233.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Feb-10, Kyotaro Horiguchi wrote: Hello, > 0006: > In extended_stats_funcs.c: > > errmsg("could not find extended statistics object \"%s\".\"%s\"", > > quote_identifier(nspname), > > quote_identifier(stxname))); > > Since quote_identifier() already adds quoting when needed, adding > "%s"."%s" in the format string results in double quoting. It would be > better to use %s.%s instead. I think quoting should be applied only > when necessary here. I'm not sure we should use > quote_qualified_identifier() instead.. (It's not used in the attached > patch). > > There's a similar inconsistency. > > > errmsg("could not clear extended statistics object \"%s\".\"%s\": incorrect relation \"%s\".\"%s\" specified", > > get_namespace_name(nspoid), stxname, > > relnspname, relname)); > > In this part, the names are not passed through quote_identifier(). It > would be better to unify this as well. Hmm, in the vast majority of messages, the quotes are in the literal string, and we do not add quote_identifier(). This way, the names are always quoted, not just when they are funny identifiers; also the translator chooses the quoting style they want, which is not necessarily the same as the one used in English. So my recommendation would be to remove the quote_identifier() calls and leave the quotes in the message. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/