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 parent107a2d4 commit52202bbCopy full SHA for 52202bb
src/bin/pg_upgrade/test.sh
@@ -167,17 +167,17 @@ createdb "regression$dbname3" || createdb_status=$?
167
if"$MAKE" -C"$oldsrc" installcheck-parallel;then
168
oldpgversion=`psql -X -A -t -d regression -c"SHOW server_version_num"`
169
170
-# before dumping, get rid of objects notexisting in later versions
+# before dumping, get rid of objects notfeasible in later versions
171
if ["$newsrc"!="$oldsrc" ];then
172
fix_sql=""
173
case$oldpgversionin
174
804??)
175
-fix_sql="DROP FUNCTION public.myfunc(integer); DROP FUNCTION public.oldstyle_length(integer, text);"
176
-;;
177
-*)
178
-fix_sql="DROP FUNCTION public.oldstyle_length(integer, text);"
+fix_sql="DROP FUNCTION public.myfunc(integer);"
179
;;
180
esac
+fix_sql="$fix_sql
+ DROP FUNCTION IF EXISTS
+public.oldstyle_length(integer, text);-- last in 9.6";
181
psql -X -d regression -c"$fix_sql;"|| psql_fix_sql_status=$?
182
fi
183