aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2018-10-12 19:33:56 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2018-10-12 19:33:56 -0400
commit9320263ae7cac206c2e82e00e42dbcddce4e8dfb (patch)
tree1647b0b4f9880d65385209b13aaba9d9c4190e6a /src
parent532e3b5b3dd278f77baa5f0b9483bf2aba226399 (diff)
downloadpostgresql-9320263ae7cac206c2e82e00e42dbcddce4e8dfb.tar.gz
postgresql-9320263ae7cac206c2e82e00e42dbcddce4e8dfb.zip
Remove abstime, reltime, tinterval tables from old regression databases.
In the back branches, drop these tables after the regression tests are done with them. This fixes failures of cross-branch pg_upgrade testing caused by these types having been removed in v12. We do lose the ability to test dump/restore behavior with these types in the back branches, but the actual loss of code coverage seems to be nil given that there's nothing very special about these types. Discussion: https://postgr.es/m/20181009192237.34wjp3nmw7oynmmr@alap3.anarazel.de
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/horology.out7
-rw-r--r--src/test/regress/expected/sanity_check.out3
-rw-r--r--src/test/regress/sql/horology.sql9
3 files changed, 16 insertions, 3 deletions
diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out
index f9d12e0f8a3..6cc6a90474c 100644
--- a/src/test/regress/expected/horology.out
+++ b/src/test/regress/expected/horology.out
@@ -3134,3 +3134,10 @@ SELECT to_char('2012-12-12 12:00'::timestamptz, 'YYYY-MM-DD HH:MI:SS TZ');
(1 row)
RESET TIME ZONE;
+--
+-- Drop tables that we don't want to keep because they interfere with
+-- testing pg_upgrade to v12 and up
+--
+DROP TABLE abstime_tbl;
+DROP TABLE reltime_tbl;
+DROP TABLE tinterval_tbl;
diff --git a/src/test/regress/expected/sanity_check.out b/src/test/regress/expected/sanity_check.out
index 6750152e0f4..8d2b449f408 100644
--- a/src/test/regress/expected/sanity_check.out
+++ b/src/test/regress/expected/sanity_check.out
@@ -13,7 +13,6 @@ SELECT relname, relhasindex
ORDER BY relname;
a|f
a_star|f
-abstime_tbl|f
aggtest|f
array_index_op_test|t
array_op_test|f
@@ -165,7 +164,6 @@ quad_point_tbl|t
radix_text_tbl|t
ramp|f
real_city|f
-reltime_tbl|f
road|t
shighway|t
slow_emp4000|f
@@ -190,7 +188,6 @@ time_tbl|f
timestamp_tbl|f
timestamptz_tbl|f
timetz_tbl|f
-tinterval_tbl|f
varchar_tbl|f
-- restore normal output mode
\a\t
diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql
index a7bc9dcfc4f..0dc980a80a3 100644
--- a/src/test/regress/sql/horology.sql
+++ b/src/test/regress/sql/horology.sql
@@ -525,3 +525,12 @@ SELECT '2012-12-12 12:00 America/New_York'::timestamptz;
SELECT to_char('2012-12-12 12:00'::timestamptz, 'YYYY-MM-DD HH:MI:SS TZ');
RESET TIME ZONE;
+
+--
+-- Drop tables that we don't want to keep because they interfere with
+-- testing pg_upgrade to v12 and up
+--
+
+DROP TABLE abstime_tbl;
+DROP TABLE reltime_tbl;
+DROP TABLE tinterval_tbl;