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 1vIYfn-005OBa-2x for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Nov 2025 20:39:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIYfl-002PQh-1c for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Nov 2025 20:39:33 +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.96) (envelope-from ) id 1vIYfl-002PQY-0I for pgsql-hackers@lists.postgresql.org; Mon, 10 Nov 2025 20:39:33 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIYfj-006Qya-0m for pgsql-hackers@postgresql.org; Mon, 10 Nov 2025 20:39:32 +0000 Received: by mail-pl1-x633.google.com with SMTP id d9443c01a7336-2964d616df7so44476075ad.3 for ; Mon, 10 Nov 2025 12:39:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1762807170; x=1763411970; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=TdxNzRLCksKEgL9cSi7EcrwufcJ74z8h8WGOhunh/E0=; b=ALSD6N64w3QinvQkHdKJv4Qd8DoslMlazbVWij4vJocb/xbefONRd2/6Jgs5pCqKj/ kd465RXljhfXlAfQLMcAV/qwRj6IWkHwMmmX5qWoMRBi+9E2NA5kmpGpaDEK/L7KFeVi kFwno8olts69hZctRVNSmY495BUnTlTOEYghZe3MH/kaM3d/YJwoPpcYIEnP9eqVt4/2 MQyNTs1oBaCuPc6t7gwvw7ftoWIYUk/260kWna7Z/7bS18a52eYqIhjbeCa+MKmdTufX MuQfkk7Dw21OqKTSBTdUyZ0jlTAajR9aJL8WDdYKiWnq/YQEQu2y4N2lnQD0xImW4JIf 0NTA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762807170; x=1763411970; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=TdxNzRLCksKEgL9cSi7EcrwufcJ74z8h8WGOhunh/E0=; b=rToeAftPzNa535UBwokYODw0QU+KQO5lF8VS3b0/nob+LZi2IboI2lK1Jx/+9bY13J l4FhH8zyhNpfxdv8dth2aJQLjOOQvL+iTeI3/M4fFGDlgJroBNAs36eD7DJi3MmWKeEP pp8HrJAZXI+m2amUFH41QIpnY82knmIFIl1kg6C5K4EPTBZU+PAWCHllNIP0BsGeE6lv mLMP5Z6QoEjDkjr64qKjzY2HA8okj95UpAumsahQMr9v68ePxo9S5LYN4Ak/5dhi4Bu1 Yt0bGnZELzEp5JXtbl2OxIviQO9DKYUXvU2d7LKZp5kr8w+qpLbItNJW3Un+t8TtdzQi ZS2A== X-Forwarded-Encrypted: i=1; AJvYcCXZUVJvAc/20tJVFQ4v3/DHOmgbfqqhWwzi/7yKJ/sbsFMBpPOv/2N1orsVXwMvUl55DVPiFOdXOXiT+fOP@postgresql.org X-Gm-Message-State: AOJu0Ywpg+ekyV2+0RcDafQrg2QiNE0gqwOpjTq33S9j+JtDhRUjslI4 /q347ixT2ZW10Grvn7Qy+rlzTbxRbx6t6HcAG7MYLAdTLZTJ2grEf/c3j1b01kRd9g== X-Gm-Gg: ASbGncvmrN3ujCMZFYg85HViFPD1yxvvztihhgRbKW3motuPEQnZ7RYSHc3OMK1N2l1 Hv0eNTJ5Jy//MkR4AQe0Yveu+OZbOcRAjZQcqSYu1FLOGNbFhpHE9Hy5ST5OyaBSWHfSkSySMv8 31GFM6K0Ott7QVz1mNkYwL0k6MuXVp7hTiwWXDJWpDMvNFCWpeLUCLvwmqgBfZp1jNuCvnMoOxA ZDSvmNp5v8e6Gh/Dg5MfOgg+h7BJFQFf7cFaXSZ1jHna5AYUkm+lbRHXw6mR1A2e2k50YgP76Ig QeggcGFzedDGXQx/3eHxb1ipzRym/k3Vyne7DuoJ66c5faZyX/FItBOz/ek4d8kQ3vat2vnXpIo c7gLMG5JTIkP8HmdXU3n5hioUyqEjuc5K/lkK8AHRWRNYO9gXDlLoT2tsv9/dfeXGUADElus2Ne 7txJaC6GEY99iG4Fl2wzAHyEdNzpjqFlaqMaOysuwbOdk= X-Google-Smtp-Source: AGHT+IHg3ybgjFxbmvGQfRxu2wbn8u3MyiQhFacjabBLtXXIVwnEZFRNEDTzxcCoAJ7ggBZjV4pJzw== X-Received: by 2002:a17:903:94e:b0:24c:da3b:7376 with SMTP id d9443c01a7336-297e5652471mr140011755ad.26.1762807170059; Mon, 10 Nov 2025 12:39:30 -0800 (PST) Received: from jeff-ws-bridge.lan (c-24-7-19-3.hsd1.ca.comcast.net. [24.7.19.3]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-29650968253sm154994125ad.20.2025.11.10.12.39.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 10 Nov 2025 12:39:29 -0800 (PST) Message-ID: Subject: Re: Remaining dependency on setlocale() From: Jeff Davis To: Daniel Verite Cc: Thomas Munro , Peter Eisentraut , Tom Lane , pgsql-hackers@postgresql.org Date: Mon, 10 Nov 2025 12:39:28 -0800 In-Reply-To: <5e709c7a-0504-426c-8a7d-e0701c334cd7@manitou-mail.org> References: <5e709c7a-0504-426c-8a7d-e0701c334cd7@manitou-mail.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-11-03 at 20:14 +0100, Daniel Verite wrote: > No, I think we should put the database's lc_ctype > into LC_CTYPE and the database's lc_collate into > LC_COLLATE, independently of anything else, > like it was done until commit 5e6e42e. > I believe that's the purpose of these database > properties, whether the provider is libc or ICU or builtin. As phrased, that appears to be a promise that we will never support thread-per-connection. setlocale() is not thread-safe, and uselocale() is not available on NetBSD. Regards, Jeff Davis