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.94.2) (envelope-from ) id 1qXWBm-006SDL-IQ for pgsql-bugs@arkaria.postgresql.org; Sun, 20 Aug 2023 00:21:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qXWBk-002mF9-LP for pgsql-bugs@arkaria.postgresql.org; Sun, 20 Aug 2023 00:21:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXWBk-002mF1-CA for pgsql-bugs@lists.postgresql.org; Sun, 20 Aug 2023 00:21:04 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXWBd-00142b-7a for pgsql-bugs@lists.postgresql.org; Sun, 20 Aug 2023 00:21:03 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 05D475C0058; Sat, 19 Aug 2023 20:20:55 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Sat, 19 Aug 2023 20:20:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm1; t=1692490855; x=1692577255; bh=hM Kmd20VTaI8aNuMJI+qfZ6Eu/r/QfktrwIQ8WXi6us=; b=cWT1n1PGmK8rxluwA8 iuy3Se+mFKSPtpR3hYEiSnYaN0Wd0+mbKUS++jGMrk6NxNqOX88PHfnkF85mTBVm w+iQ5HW+T61hDsppeqqUFqKLhK3yQNGjNif/oTkAen8p5YyfahsiDyCt8fePqmzA +IBUY7yu4yufzxpuUqhAOS934ZtfAh/RN35K6ynCoQFwhOB28QUXXwdU0/W2Nll8 fPcao81LbOKiIL5o7wOAWzXFdFtAvfWLs03il2+wb2Y98ul4j6SLuy98oi/oq5zp D3gFIwQ936WaeH3j0ojdWrXHiuE3RZ0bozBF46CTmur5OhaFXGCkJGVZBRvSI0GP sC8g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1692490855; x=1692577255; bh=hMKmd20VTaI8a NuMJI+qfZ6Eu/r/QfktrwIQ8WXi6us=; b=K8UqwkPnzloTejW/PFQIYqfHHuUx0 UnqmjcKqEadH/PwLV72Uw6YeEYGSXGz1xan0tZYNaL8UTWrBjxzgsltbQ4aBH97d HqAPXXUKqV1hULlteK13bPwftTLAGrLaZiIahMaBxvoAO62FjSNAk38QQ1l8Wb/d vuZ589Gv5Uiej31haj78oo/U5Wue2gcDi+rbpwz7nZcC4eiQ7oHY1V53aDM/INF8 pSbgPKReSINCgPE7rQkF4SbB80tnPIUPCdpqDWPsoy7LUiZ9NUNOfAQAU9SEz3nP egN1J8hmz3oorBCXcUVrlwsFcEAdew1Wmbnl4ooOUy4XxLuoVsucZAD/w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudduiedgfeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvvefukfhfgggtuggjsehgtdorredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepffduleehgefhkeefgfeftdfhkedutddvhfdukeeggeehieekffelhfelkeehteef necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 19 Aug 2023 20:20:52 -0400 (EDT) Date: Sun, 20 Aug 2023 09:20:48 +0900 From: Michael Paquier To: Tom Lane Cc: martin@schlossarek.me, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18057: unaccent removes intentional spaces Message-ID: References: <18057-62712cad01bd202c@postgresql.org> <2334732.1692462604@sss.pgh.pa.us> <2399066.1692490106@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="F8+DaRVg6inJU92T" Content-Disposition: inline In-Reply-To: <2399066.1692490106@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --F8+DaRVg6inJU92T Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Aug 19, 2023 at 08:08:26PM -0400, Tom Lane wrote: > I was envisioning following SQL identifier rules, that is you double > the double quote. Then the existing " entries would have to become > """", which isn't much fun. But what you're suggesting would make > both " and \ into magic characters, doubling the chance of problems > with existing rules files. Apologies for the confusion. I was thinking to also escape \ in quoted strings. Your suggestion to use a second double-quote for the escaping is fine by me. """" feels a bit ugly-ish in the rules file, for sure, but that does not look like a huge issue to me as long as the python script generates consistent contents ;) -- Michael --F8+DaRVg6inJU92T Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmThXGAACgkQnvQgOdby QH1WQg/+PSCKsya0Ig9xoWyEU1qYM1/vQ0b87+/9b6kfOCfeGjoo8zOdUYgtxit9 7/tAUxhcDLKUEE662CvxRefEQAtvKb+ATm871qaOVIWQeII2YSgUABgOehAPFmMq /IlZPkG9RscsCKugmrNNEFYbNTuvM6Qn0bXDtTFqAgtT5PXXyzXPZo3Gg4KRz4GP aPTK9VOeR+lewBYr7HsuDZCF0l5mbMnEgUv1nqmKj6eONLYLEZa2CnjUWhfpL504 7Y/ag34rZ7F/Qymhp7BPX59AmYWBu96onWHet6SmAoO6FnCV2+3K/498vFV14G37 uAGWmdJUOjGdEKtAMMd2qb6PN2Un6Posky/2MzW6R11/4lIjLIZPVSRHrZuhvFF8 ooPdZgFq1fSIYtEOr/DW0haLa3mUF5jhwlnrvnKJYgc2vpcVbuKPl1pJ2WuXfquU pKV/jrFHl8G9+uJ+r5P3plNrD2keVmGWHlYwogDRRlk+jPugaLr6k8jJPJ8Uas9D TqYS1UVrM/hAiQWhNph4UOVC+B/d0fEUquuaBz/+tSHRtpfHo62rQHO9Xg8JpoLv /WaFIpQ0U7fDd61LRPUNrn8Ok9rcFyEfWJ26GT7ECRGyvK0Sp6hItO8qjWcr2EBs oP6U/t6s/SC00lvuuZVe4H4V/R533+epMUPo2I/n2LC2lRyEomg= =PGzH -----END PGP SIGNATURE----- --F8+DaRVg6inJU92T--