From 3556c89321e8baa2242288bd4f015efd1e9d6be0 Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Fri, 4 Apr 2025 10:28:52 -0700 Subject: [PATCH] Oversight in commit b81ffa13e3. Should warn if a materialized view may be affected, as well. --- src/bin/pg_upgrade/check.c | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/bin/pg_upgrade/check.c b/src/bin/pg_upgrade/check.c index 3189de4df96..8f946c4e3d6 100644 --- a/src/bin/pg_upgrade/check.c +++ b/src/bin/pg_upgrade/check.c @@ -1911,6 +1911,10 @@ check_for_unicode_update(ClusterInfo *cluster) " UNION " " SELECT partrelid " " FROM pg_partitioned_table, patterns WHERE partexprs::text ~ p " + " UNION " + " SELECT ev_class " + " FROM pg_rewrite, pg_class, patterns " + " WHERE ev_class = pg_class.oid AND relkind = 'm' AND ev_action::text ~ p" " ) s(reloid), pg_class c, pg_namespace n, pg_database d " " WHERE s.reloid = c.oid AND c.relnamespace = n.oid AND " " d.datname = current_database() AND " -- 2.39.5