Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit9320263

Browse files
committed
Remove abstime, reltime, tinterval tables from old regression databases.
In the back branches, drop these tables after the regression tests aredone with them. This fixes failures of cross-branch pg_upgrade testingcaused by these types having been removed in v12. We do lose the abilityto test dump/restore behavior with these types in the back branches, butthe actual loss of code coverage seems to be nil given that there's nothingvery special about these types.Discussion:https://postgr.es/m/20181009192237.34wjp3nmw7oynmmr@alap3.anarazel.de
1 parent532e3b5 commit9320263

File tree

3 files changed

+16
-3
lines changed

3 files changed

+16
-3
lines changed

‎src/test/regress/expected/horology.out

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3134,3 +3134,10 @@ SELECT to_char('2012-12-12 12:00'::timestamptz, 'YYYY-MM-DD HH:MI:SS TZ');
31343134
(1 row)
31353135

31363136
RESET TIME ZONE;
3137+
--
3138+
-- Drop tables that we don't want to keep because they interfere with
3139+
-- testing pg_upgrade to v12 and up
3140+
--
3141+
DROP TABLE abstime_tbl;
3142+
DROP TABLE reltime_tbl;
3143+
DROP TABLE tinterval_tbl;

‎src/test/regress/expected/sanity_check.out

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -13,7 +13,6 @@ SELECT relname, relhasindex
1313
ORDER BY relname;
1414
a|f
1515
a_star|f
16-
abstime_tbl|f
1716
aggtest|f
1817
array_index_op_test|t
1918
array_op_test|f
@@ -165,7 +164,6 @@ quad_point_tbl|t
165164
radix_text_tbl|t
166165
ramp|f
167166
real_city|f
168-
reltime_tbl|f
169167
road|t
170168
shighway|t
171169
slow_emp4000|f
@@ -190,7 +188,6 @@ time_tbl|f
190188
timestamp_tbl|f
191189
timestamptz_tbl|f
192190
timetz_tbl|f
193-
tinterval_tbl|f
194191
varchar_tbl|f
195192
-- restore normal output mode
196193
\a\t

‎src/test/regress/sql/horology.sql

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -525,3 +525,12 @@ SELECT '2012-12-12 12:00 America/New_York'::timestamptz;
525525
SELECT to_char('2012-12-12 12:00'::timestamptz,'YYYY-MM-DD HH:MI:SS TZ');
526526

527527
RESETTIME ZONE;
528+
529+
--
530+
-- Drop tables that we don't want to keep because they interfere with
531+
-- testing pg_upgrade to v12 and up
532+
--
533+
534+
DROPTABLE abstime_tbl;
535+
DROPTABLE reltime_tbl;
536+
DROPTABLE tinterval_tbl;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp