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">&sect;</ulink> +<ulink url="&commit_baseurl;b96a9fd76f3">&sect;</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">&sect;</ulink> -</para> -</listitem> - <!-- Author: Michael Paquier <michael@paquier.xyz> 2026-02-05 [3c5ec35de] oid2name: Add relation path to the information provided [parent: 5aed88ff9f36]