[18+] improve upgrade pre-check for Unicode updates

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>
To: pgsql-hackers@postgresql.org
Date: 2025-08-22T21:48:07Z
Lists: pgsql-hackers

Attachments

Patch attached.

When checking for expression indexes that may be affected by a Unicode
update during upgrade, check for a few more functions. Specifically,
check for documented regexp functions, as well as the new CASEFOLD()
function.
    
Also, fully-qualify pg_catalog references to the text type as well as
regtype.

Regards,
	Jeff Davis

Commits

  1. Check for more Unicode functions during upgrade.