postgres.git / summary / log / commit / refs
commit 14870d5a18083e51db5a2e85ee95a188c8ff1d52
Author: Jeff Davis <jdavis@postgresql.org>
Date: Fri Oct 30 17:56:24 2026 +0000
First released in: 19.0
PG 19: expand release notes for fuzzystrmatch.
Also move to the Migration section and add a note about reindexing.
Suggested-by: shihao zhong <zhong950419@gmail.com>
Discussion: https://postgr.es/m/CAGRkXqRWpqmoCBffoLViAVAK2-_hYE_z1SW=FfejPidT6wPgdA@mail.gmail.com
doc/src/sgml/release-19.sgml | 38 ++++++++++++++++++++++++++------------
1 file changed, 26 insertions(+), 12 deletions(-)
diff --git a/doc/src/sgml/release-19.sgml b/doc/src/sgml/release-19.sgml
index 6110b4f162c..253fa07179a 100644
--- a/doc/src/sgml/release-19.sgml
+++ b/doc/src/sgml/release-19.sgml
@@ -405,6 +405,32 @@ upgrade, and to recompute any stored <type>tsvector</type> values.
</para>
</listitem>
+<!--
+Author: Peter Eisentraut <peter@eisentraut.org>
+2026-01-12 [e39ece034] Make dmetaphone collation-aware
+Author: Jeff Davis <jdavis@postgresql.org>
+2026-01-12 [b96a9fd76f3] fuzzystrmatch: use pg_ascii_toupper().
+-->
+
+<listitem>
+<para>
+Change how <xref linkend="fuzzystrmatch"/> functions handle
+non-<acronym>ASCII</acronym> characters (Peter Eisentraut, Jeff Davis)
+<ulink url="&commit_baseurl;e39ece034">§</ulink>
+<ulink url="&commit_baseurl;b96a9fd76f3">§</ulink>
+</para>
+
+<para>
+<function>dmetaphone()</function> and <function>dmetaphone_alt()</function>
+now upper-case their input using the database's default collation rather than
+always using libc, and <function>soundex()</function>,
+<function>metaphone()</function>, and <function>difference()</function> now
+treat only <acronym>ASCII</acronym> letters as letters. When upgrading with
+<link linkend="pgupgrade"><application>pg_upgrade</application></link>, it is
+recommended to reindex any indexes that use these functions after the upgrade.
+</para>
+</listitem>
+
<!--
Author: Thomas Munro <tmunro@postgresql.org>
2026-04-08 [77645d44e] Remove MULE_INTERNAL encoding.
@@ -3263,18 +3289,6 @@ Improve performance of <xref linkend="pgstattuple"/> by using streaming reads (X
</para>
</listitem>
-<!--
-Author: Peter Eisentraut <peter@eisentraut.org>
-2026-01-12 [e39ece034] Make dmetaphone collation-aware
--->
-
-<listitem>
-<para>
-Allow <xref linkend="fuzzystrmatch"/>'s <function>dmetaphone()</function> to use single-byte encodings beyond <acronym>ASCII</acronym> (Peter Eisentraut)
-<ulink url="&commit_baseurl;e39ece034">§</ulink>
-</para>
-</listitem>
-
<!--
Author: Michael Paquier <michael@paquier.xyz>
2026-02-05 [3c5ec35de] oid2name: Add relation path to the information provided
[parent: 5aed88ff9f36]