We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent5253906 commit2392136Copy full SHA for 2392136
src/bin/pg_upgrade/test.sh
@@ -169,17 +169,17 @@ createdb "regression$dbname3" || createdb_status=$?
169
if"$MAKE" -C"$oldsrc" installcheck-parallel;then
170
oldpgversion=`psql -X -A -t -d regression -c"SHOW server_version_num"`
171
172
-# before dumping, get rid of objects notexisting in later versions
+# before dumping, get rid of objects notfeasible in later versions
173
if ["$newsrc"!="$oldsrc" ];then
174
fix_sql=""
175
case$oldpgversionin
176
804??)
177
-fix_sql="DROP FUNCTION public.myfunc(integer); DROP FUNCTION public.oldstyle_length(integer, text);"
178
-;;
179
-*)
180
-fix_sql="DROP FUNCTION public.oldstyle_length(integer, text);"
+fix_sql="DROP FUNCTION public.myfunc(integer);"
181
;;
182
esac
+fix_sql="$fix_sql
+ DROP FUNCTION IF EXISTS
+public.oldstyle_length(integer, text);-- last in 9.6";
183
psql -X -d regression -c"$fix_sql;"|| psql_fix_sql_status=$?
184
fi
185