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 1seaU3-0097rx-Lp for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Aug 2024 13:25:43 +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 1seaU2-00GifP-80 for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Aug 2024 13:25:42 +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 1seaU1-00GifB-UH for pgsql-hackers@lists.postgresql.org; Thu, 15 Aug 2024 13:25:41 +0000 Received: from fhigh6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1seaTy-004rpf-Tq for pgsql-hackers@postgresql.org; Thu, 15 Aug 2024 13:25:40 +0000 Received: from phl-compute-06.internal (phl-compute-06.nyi.internal [10.202.2.46]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 4C5041151BE0; Thu, 15 Aug 2024 09:25:37 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Thu, 15 Aug 2024 09:25:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1723728337; x=1723814737; bh=A2PM7s7/lsEdNQ7vis9imc3pplStZC7J gsqRrHgHyYc=; b=kkSkyNivrxpHhuzlWs3/cj3kgPvlIag5pUhrayIn8buMewgG XRWyeVYyToennQc56cuoO50dILmEtBaSkPo0mvqodfvwoaeqBUPEYujYo4FAIODw ie/J80/O3C7G4br5rqHs3JCT9fviH7s4zGQ+LTJQ86d1NRJ6enfM9NKsEPZzMiaq ky04dM8lIl5ow4eLk+tHivi+FnzD0CaZArlhrIAGkXFtEq0SUjM1khygIABSwTfz hKVioBYGHXS4qJawOx9jIqe09RntAY6Y0mfGA38PVjHFun3oOKqZrSVQzXq6ZREE glbVp1pdfa/rPbo/L79jX1uY+tmB53nut4IfTA== 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 :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1723728337; x= 1723814737; bh=A2PM7s7/lsEdNQ7vis9imc3pplStZC7JgsqRrHgHyYc=; b=b 3k3WQ46rv/A6wxZ3nRDXveJIbf3/kOK5hN5bx5sO0PXT8Q0f4zFSRBeoCVUh3j9H 16Alr5adQPfdg7g4sJOsMmpkEaUJlt2d9y1yvXZ3kG1vifBkQc2181Qgw8WXDCTy ZxXafNYSKfB5eSZaGZAmph4oPClBbVgL6qyGzrNEnBGXD89Ynh7a/juzZEynCtak M4pXtro3DS3FjjwVGDWty7aVI9/Xlu6VCYZukDDH/ZuDQQby/1XVzPtIMfR6DlHE l1esgdMzzqyZ3PM7nU+2pCClFSCbpnbz4W8U54NycIHp1qy8qNsdVc6RkgcU2U/v lUDpPM2GETfolZRxKqcFw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddtiedgieefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvg hnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileeh teeljeeghfeuledthfeutedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdho rhhgpdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtthhope hthhhomhgrshdrmhhunhhrohesghhmrghilhdrtghomhdprhgtphhtthhopehtghhlsehs shhsrdhpghhhrdhprgdruhhspdhrtghpthhtohepphhgshhqlhesjhdquggrvhhishdrtg homhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdr ohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 15 Aug 2024 09:25:36 -0400 (EDT) Message-ID: <80ca0504-61f1-42c8-b5f2-cfef07004cf4@eisentraut.org> Date: Thu, 15 Aug 2024 15:25:35 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Remaining dependency on setlocale() To: Thomas Munro , Tom Lane Cc: Jeff Davis , pgsql-hackers@postgresql.org References: <4c5da86af36a0d5e430eee3f60ce5e06f1b5cd34.camel@j-davis.com> <1841102.1722982989@sss.pgh.pa.us> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 15.08.24 00:43, Thomas Munro wrote: > "" is a problem however... the special value for "native environment" > is returned as a real locale name, which we probably still need in > places. We could change that to newlocale("") + query instead, but Where do we need that in the server? It should just be initdb doing that and then initializing the server with concrete values based on that. I guess technically some of these GUC settings default to the environment? But I think we could consider getting rid of that.