Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit08aa8f0

Browse files
committed
Check for more Unicode functions during upgrade.
When checking for expression indexes that may be affected by a Unicodeupdate during upgrade, check for a few more functions. Specifically,check for documented regexp functions, as well as the new CASEFOLD()function.Also, fully-qualify references to pg_catalog.text andpg_catalog.regtype.Discussion:https://postgr.es/m/399b656a3abb0c9283538a040f72199c0601525c.camel@j-davis.comBackpatch-through: 18
1 parentbf37808 commit08aa8f0

File tree

1 file changed

+9
-4
lines changed

1 file changed

+9
-4
lines changed

‎src/bin/pg_upgrade/check.c‎

Lines changed: 9 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1971,14 +1971,19 @@ check_for_unicode_update(ClusterInfo *cluster)
19711971
" SELECT oper.oid, oper.oprcode, collid FROM pg_operator oper, collations "
19721972
" WHERE oprname IN ('~', '~*', '!~', '!~*', '~~*', '!~~*') AND "
19731973
" oprnamespace='pg_catalog'::regnamespace AND "
1974-
" oprright='text'::regtype "
1974+
" oprright='pg_catalog.text'::pg_catalog.regtype "
19751975
"), "
19761976
/* functions that use the input collation for character semantics */
19771977
"coll_functions(procid, collid) AS ( "
19781978
" SELECT proc.oid, collid FROM pg_proc proc, collations "
1979-
" WHERE proname IN ('lower','initcap','upper') AND "
1980-
" pronamespace='pg_catalog'::regnamespace AND "
1981-
" proargtypes[0] = 'text'::regtype "
1979+
" WHERE pronamespace='pg_catalog'::regnamespace AND "
1980+
" ((proname IN ('lower','initcap','upper','casefold') AND "
1981+
" pronargs = 1 AND "
1982+
" proargtypes[0] = 'pg_catalog.text'::pg_catalog.regtype) OR "
1983+
" (proname = 'substring' AND pronargs = 2 AND "
1984+
" proargtypes[0] = 'pg_catalog.text'::pg_catalog.regtype AND "
1985+
" proargtypes[1] = 'pg_catalog.text'::pg_catalog.regtype) OR "
1986+
" proname LIKE 'regexp_%') "
19821987
/* include functions behind the operators listed above */
19831988
" UNION "
19841989
" SELECT procid, collid FROM coll_operators "

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp