diff options
| author | Noah Misch <noah@leadboat.com> | 2020-12-30 01:43:43 -0800 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2020-12-30 01:43:43 -0800 |
| commit | 52202bb396b1e96c43bfd767d6e434b1c6fd2ae1 (patch) | |
| tree | 2c583884954c6efe34c3bcf37ca78ca1aafd6e48 | |
| parent | 107a2d4204ff4bf4ce05e3525f0d94fc0bd497ff (diff) | |
| download | postgresql-52202bb396b1e96c43bfd767d6e434b1c6fd2ae1.tar.gz postgresql-52202bb396b1e96c43bfd767d6e434b1c6fd2ae1.zip | |
In pg_upgrade cross-version test, handle lack of oldstyle_length().
This suffices for testing v12 -> v13; some other version pairs need more
changes. Back-patch to v10, which removed the function.
| -rw-r--r-- | src/bin/pg_upgrade/test.sh | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/bin/pg_upgrade/test.sh b/src/bin/pg_upgrade/test.sh index 04aa7fd9f51..a2da1abe3f1 100644 --- a/src/bin/pg_upgrade/test.sh +++ b/src/bin/pg_upgrade/test.sh @@ -167,17 +167,17 @@ createdb "regression$dbname3" || createdb_status=$? if "$MAKE" -C "$oldsrc" installcheck-parallel; then oldpgversion=`psql -X -A -t -d regression -c "SHOW server_version_num"` - # before dumping, get rid of objects not existing in later versions + # before dumping, get rid of objects not feasible in later versions if [ "$newsrc" != "$oldsrc" ]; then fix_sql="" case $oldpgversion in 804??) - fix_sql="DROP FUNCTION public.myfunc(integer); DROP FUNCTION public.oldstyle_length(integer, text);" - ;; - *) - fix_sql="DROP FUNCTION public.oldstyle_length(integer, text);" + fix_sql="DROP FUNCTION public.myfunc(integer);" ;; esac + fix_sql="$fix_sql + DROP FUNCTION IF EXISTS + public.oldstyle_length(integer, text); -- last in 9.6"; psql -X -d regression -c "$fix_sql;" || psql_fix_sql_status=$? fi |