In pg_upgrade cross-version test, handle postfix operators.

nmisch · nmisch · commit fa744697c791 · 2020-12-30T01:43:43.000-08:00
Commit 1ed6b89 eliminated support for them, so drop them from regression databases before upgrading. This is necessary but not sufficient for testing v13 -> v14 upgrades. Discussion: https://postgr.es/m/449144.1600439950@sss.pgh.pa.us
diff --git a/src/bin/pg_upgrade/test.sh b/src/bin/pg_upgrade/test.sh
@@ -177,7 +177,12 @@ if "$MAKE" -C "$oldsrc" installcheck-parallel; then
 		esac
 		fix_sql="$fix_sql
 				 DROP FUNCTION IF EXISTS
-					public.oldstyle_length(integer, text);	-- last in 9.6";
+					public.oldstyle_length(integer, text);	-- last in 9.6
+				 DROP OPERATOR IF EXISTS	-- last in v13
+					public.#@# (pg_catalog.int8, NONE),
+					public.#%# (pg_catalog.int8, NONE),
+					public.!=- (pg_catalog.int8, NONE),
+					public.#@%# (pg_catalog.int8, NONE);"
 		psql -X -d regression -c "$fix_sql;" || psql_fix_sql_status=$?
 	fi
 
