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 1u4O0X-001PPY-SA for pgsql-general@arkaria.postgresql.org; Mon, 14 Apr 2025 17:54:10 +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 1u4O0V-0044Gd-D8 for pgsql-general@arkaria.postgresql.org; Mon, 14 Apr 2025 17:54:08 +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 1u4O0V-0044GP-2B for pgsql-general@lists.postgresql.org; Mon, 14 Apr 2025 17:54:07 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4O0T-0003j5-2f for pgsql-general@lists.postgresql.org; Mon, 14 Apr 2025 17:54:06 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-43cf05f0c3eso33147515e9.0 for ; Mon, 14 Apr 2025 10:54:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744653245; x=1745258045; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=e7vdlqmb1QbBmW2Z1Ig8Y4fsuDK4GJ0zITlgbw2O9Yo=; b=F4ZMFQErLJD1cowC5tTRJfoO1jF00DridR0UWo1IXaZ0WWNv5YeNe0JXnIklB4eEZP S2S9rqm/NHuFiymSZ0SKkzNeJcT2mU115bnWNbDc+GuQiSzEqU9tLcxg2MXubE2TrH12 ncnbTaUFZs9DaLrmWnTsxc0/jpeu/dyAmvOxYkVy8zhPcF3BvSTz48PnW3tzt/3oLjV2 2ZUFfuUEeWyCfCfFFyScxzkLO0MLBtCdlEzR1Qi1GBZxBAI24I8mAttJkfGv1vJsk3z8 Nrw4MXaG2wKGtWER6ECL9AH2hC6lyet/AfHAcVWAZhMJFKC3UvM/dvB1Uv1uNpqBiLw1 VMcg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744653245; x=1745258045; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=e7vdlqmb1QbBmW2Z1Ig8Y4fsuDK4GJ0zITlgbw2O9Yo=; b=jbQZgHhdTaY88uP8XjGPMhls/jwiA9kJx05PB69FCp7KvTMla8CLC5AVX4yJkR0N87 pnZYj4hUY3GoBn3pB/qeZr3NknLWzZq7MNajW3npUNv29lSMHST66XZSEBlt5A/Hfc9z evR2WGRmU4yviMLk3v5Qa4Bd131XqWFm0Zm+81aOuHOxZgrogLayjJ4hX/lDqg2XrbfC IiciM6o8JUzDjdjl/5TR2d7FQ52l6TmcYfw+AgQyrAITlt6we3mUCOzyRu1yTLHReC4n Nq3aeLO8lI8zz28m5CxaHvr1M2LXf+iLIpxaIRqdbeKRumFpXCWTeTRN3h1T7eEJKtDC ymFg== X-Forwarded-Encrypted: i=1; AJvYcCXZbmDFPiCQ4brvq9aWAGCuYdKNFzEfLXsf8TBFLaAYRlSdA/agc6VbyTWrqvxZ166l42dFZdBfPq/yyntA@lists.postgresql.org X-Gm-Message-State: AOJu0YyU64JzK4CH/513i+v6R3TJe27ToW2o30pPAlNDzofc/6xlrg2/ Hy/UU7JuT94BwVfmoNFZzxCq9MgRlbOBHVgvndB1z2goKK7DyJqoXOEm2w== X-Gm-Gg: ASbGncuf5t3tVndgHt/NWULq4jmjSG+3T/7RICpiy0C0ZmHzoz+7/7xymuTkLluEwA7 cyYWVL0teEnLLICEtJPXkP5+RiPg7K/2sVk+eYavmscL00jTTFNmRygnRcPuBo8XR4Wyrq15OLs gq2SnpliENeldNImeU9HgLBMFTZBlroifdcwtYyHja3uDeVz87mPOWMvT+pmVVXkle/WboqgmV4 3xY1vGgVl/0sLsAoislvCoiiMBUHWG86B+mwKz/75PRQJKzr+oJo+TTWPVPayRod0P7TRfAPb2D lzseRzqAD9tXrw3nKZxM3eoL84iujo8unFKcdG0Kkfw3RXwvjxFOeYc+zWXU8uypI6krEwwfdfg gjFE5TyttZZqRYn1bPg== X-Google-Smtp-Source: AGHT+IHe6K11RxjqfYe0IWY5WLEyGsTOXWyybktnEM8HoWnyldqUW0Bt2OnKjPg7HlaYHUcbq8n24g== X-Received: by 2002:a05:600c:34c5:b0:43c:eec7:eabb with SMTP id 5b1f17b1804b1-43f3a93cac9mr105454635e9.8.1744653244402; Mon, 14 Apr 2025 10:54:04 -0700 (PDT) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-43f20a0bf4esm93560025e9.1.2025.04.14.10.54.02 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 14 Apr 2025 10:54:03 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\)) Subject: Re: ICU Collations and Collation Updates From: Paul Foerster In-Reply-To: Date: Mon, 14 Apr 2025 19:53:32 +0200 Cc: Tom Lane , Thomas Michael Engelke , pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <8ed41c50ba6c5322296b869e497c1b5573853b54.camel@posteo.de> <1257278.1744641400@sss.pgh.pa.us> <23A7395F-6134-4D9E-8489-8F3BCE49E156@gmail.com> To: =?utf-8?Q?Cybertec_Sch=C3=B6nig_=26_Sch=C3=B6nig_GmbH?= X-Mailer: Apple Mail (2.3826.500.181.1.5) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Laurenz, > On 14 Apr 2025, at 19:36, Laurenz Albe = wrote: >=20 > You cannot "bake in into" PostgreSQL, but you can grab the ICU source, > install it in /usr/local or similar and build PostgreSQL against that. > You will have to fiddle with CFLAGS and LDFLAGS so that the build = process > uses the C headers and libraries from your build of the ICU library. I think I'm going to look into this. I'm not a developer, so I'll = probably fail. Building PostgreSQL from source is easy and well = documented. I have scripted this. But other than that, I'll probably = fail. =F0=9F=A4=A3 Still worth a try, though. Thanks, Paul=