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 1vioF8-00G4co-2T for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jan 2026 06:32:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vioF7-00BWgr-2n for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Jan 2026 06:32:34 +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 1vioF7-00BWgi-1a for pgsql-hackers@lists.postgresql.org; Thu, 22 Jan 2026 06:32:33 +0000 Received: from mail-yx1-xb136.google.com ([2607:f8b0:4864:20::b136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vioF4-001ivw-1X for pgsql-hackers@postgresql.org; Thu, 22 Jan 2026 06:32:32 +0000 Received: by mail-yx1-xb136.google.com with SMTP id 956f58d0204a3-64938fce805so707237d50.1 for ; Wed, 21 Jan 2026 22:32:31 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769063550; cv=none; d=google.com; s=arc-20240605; b=BdY9Z6dzxaFJMX+Zfr4SL7szACiJ2y9q7YPtOpFl91JwtVYLKDuVNdfnRKHpGT9c+1 qc4jnO5EmL17pMfP6tvSb6QEXiHi95LZziE0lFvAnzoXlKyusncOtAauQlg5yin7KzTc 30csanj7AYgQ5Y29r6gMXacmlWNaxuTcyc62KtjBpjxlk+4af4RfX8YVFvp5EK92Fr2r Z8wrxAKD81pt7a3QozrckMHdhTKiJc+0tNkxy3bTrBase+kDBEWiR5AojnYy4f4d9e7g PVxmg4eRQCC8MVcYS7u/NUn14WFHpGElVKJ3ZDrI3mP4E47QJY9f7KvpOihWSd9nwqD3 +SGA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=bgfIFojjg/bcA/4Ka0Ft6z3xe8smcWwr0fIqm073B+0=; fh=rPXvXL2Y/tAAQ3AxBoo51Y+1DCrbDsJcP6821qh63Gk=; b=A3Ola6w4Oe+IjNTmBFDglRMzc64HsDmq+yRQftQ40ap8oLZiBjSVQt5cllyx7dZvBg VjPhD4I8BU5tThGyKVSpbbVD+nSzG5nDTd3k3VNGMqq1CRNIayV3unNE4Cxw9kMNuvW8 +07+u5Nj1+PpQ/rldlOzgAPMn+l5F1ysAmlPlB/4AMEfwZgLzL8BmUtz8gHhaJ3hwz7p 9aRslrZt83qM4bwcVfixrewTaQ19iaW/Gewz6Ayw1nLpmfQDbLN7NX0a+4r5mYscgNjd oQl+pQHPlzMoRCICPhIyuQ/Bv4P9JBUMs97Uw2JLZHZymvUmOvXlYWAfMj5CgIDP9LGi egxA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1769063550; x=1769668350; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=bgfIFojjg/bcA/4Ka0Ft6z3xe8smcWwr0fIqm073B+0=; b=hzz9i4xS86Tuxz5vuDSdBEHgTtmcqbvkuGxF5BRkQtipX2xK+5Km2TynnHvBL7/WyU g/bkTl5TIN4RK2GscpCHx1PbjOxkHOe1MxSb2zPXernckgtSjIu81dBo2c9nmwPHXRxk 7EBdS5BXahbqrMpTYVOBRVY2SzLqEMNnzEyZg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769063550; x=1769668350; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=bgfIFojjg/bcA/4Ka0Ft6z3xe8smcWwr0fIqm073B+0=; b=E6sk91bmRsBvbECJqxLRIlDvoiHeh4quTz13CrfHQOFMjbRxKnBV1hJ5r2LVhSXluR elLSJNkCzgu2XQ0OSPCIuKtyQ1gCi6mJZWtejBiNyGUqKlXKB3a5tuuSvQDxl8yJQZ79 8YL7rC5gqvE9rhPCYRHY5Oo5eNZ5Lgt7lMC0uIU2tp6sJKufNecE1r0yYiMc2mmtxACx Hz7iUbn19TxZfyjxsikL+lG2rtRtpJay5W2iWadptAyNqWy7LnyZV9uPxZ4E4hnFlJjb Dfj3WgBzvy6308VTPY449hmwziRkG8mkQHwZArXSxxvJALkE6rw65GCEAwSgWJC+qYJi Xxew== X-Gm-Message-State: AOJu0YxBru/Ehi/T4HwRMH+0ZLA+5X6cMrbH9HCkcQ4gqk2eQfPsUVjG t+C+P72xCpeFynl3fCtFCnGzlby2HntpICYDqAN4fjiD2LPUeeoo8vFGUXxmJy1OMFDf3PWTp4H FM4RzDWVUhTOTSNBu+0PXDOxOkS0F9S1azSKHHbhxHMumtztio6wMxfZvG2KPbmyl97PfJJ9iNq +eH4TWTYLN+RXOO/D6JUsFr0HGmHgUzIN+z2HQRPrUZsaznNn5nsqA4LfvOdtEUE3z7uiesRjmv eYSvGgsmik+M8Ux4MCaSjT8k544ewPEmgpSNr5HV+qtvP44XIU= X-Gm-Gg: AZuq6aJkUv6G2W5J4qHIaFVpOk+Zh9Ne38R7n6ZF3A5aqPAaxo2Du0Rvynk6ATvOULT XFjakyrKRafQwFGwVUGZaQK6nYc8NEXeno+YGLYqTO4xlTTxdPbgfYkuW8oeyUaydle72cYF7GK G2YsLl8coHRHMrF2ihDmyDHj5cjuOsDqpoyEfTkfqR9P10agp0REjHD9l0bos9dsK5LGfpDB9eD 2JdnomBQJ/JKZS/oug4wRTbnAcz59pWHVXa9PeNvEW6a8drefBhPFivRVJEVZje043MDFgpqWKJ 3yXTWziMhhEQEBXGpJLOhKQmFjOCHKXMPQxEBW6aVhi+oMf4WpmplnvM0mAkzDSD1rA= X-Received: by 2002:a05:690e:4185:b0:644:702c:3c02 with SMTP id 956f58d0204a3-6493c856390mr5467443d50.70.1769063550441; Wed, 21 Jan 2026 22:32:30 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Zsolt Parragi Date: Thu, 22 Jan 2026 06:32:20 +0000 X-Gm-Features: AZwV_Qgq_Z7rTMxInWig5qASQ82eggg6awnNR41NP8AKP5XzJMiyvl94q0gDEvg Message-ID: Subject: Re: Use correct collation in pg_trgm To: David Geier Cc: pgsql-hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello! The patch is simple and it does what it says it does, I verified the difference in behavior with/without it. I think the test case included in the email should be part of the patch, maybe as a new file contrib/pg_trgm/sql/pg_trgm_collation.sql? It also needs a proper commit message, and seems like the affected indexes will need a REINDEX after this fix.