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

Commit3a6e407

Browse files
committed
Update regression tests for \d+ modification
Noted by Tom
1 parentebcadba commit3a6e407

File tree

1 file changed

+57
-57
lines changed

1 file changed

+57
-57
lines changed

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

Lines changed: 57 additions & 57 deletions
Original file line numberDiff line numberDiff line change
@@ -945,34 +945,34 @@ CREATE TABLE t4 (a text, c text);
945945
ALTER TABLE t4 ALTER COLUMN c SET STORAGE EXTERNAL;
946946
CREATE TABLE t12_storage (LIKE t1 INCLUDING STORAGE, LIKE t2 INCLUDING STORAGE);
947947
\d+ t12_storage
948-
Table "public.t12_storage"
949-
Column | Type | Modifiers | Storage | Description
950-
--------+------+-----------+----------+-------------
951-
a | text | not null | main |
952-
b | text | | extended |
953-
c | text | | external |
948+
Table "public.t12_storage"
949+
Column | Type | Modifiers | Storage |Stats target |Description
950+
--------+------+-----------+----------+--------------+-------------
951+
a | text | not null | main | |
952+
b | text | | extended | |
953+
c | text | | external | |
954954
Has OIDs: no
955955

956956
CREATE TABLE t12_comments (LIKE t1 INCLUDING COMMENTS, LIKE t2 INCLUDING COMMENTS);
957957
\d+ t12_comments
958-
Table "public.t12_comments"
959-
Column | Type | Modifiers | Storage | Description
960-
--------+------+-----------+----------+-------------
961-
a | text | not null | extended | A
962-
b | text | | extended | B
963-
c | text | | extended | C
958+
Table "public.t12_comments"
959+
Column | Type | Modifiers | Storage |Stats target |Description
960+
--------+------+-----------+----------+--------------+-------------
961+
a | text | not null | extended | |A
962+
b | text | | extended | |B
963+
c | text | | extended | |C
964964
Has OIDs: no
965965

966966
CREATE TABLE t1_inh (LIKE t1 INCLUDING CONSTRAINTS INCLUDING COMMENTS) INHERITS (t1);
967967
NOTICE: merging column "a" with inherited definition
968968
NOTICE: merging column "b" with inherited definition
969969
NOTICE: merging constraint "t1_a_check" with inherited definition
970970
\d+ t1_inh
971-
Table "public.t1_inh"
972-
Column | Type | Modifiers | Storage | Description
973-
--------+------+-----------+----------+-------------
974-
a | text | not null | main | A
975-
b | text | | extended | B
971+
Table "public.t1_inh"
972+
Column | Type | Modifiers | Storage |Stats target |Description
973+
--------+------+-----------+----------+--------------+-------------
974+
a | text | not null | main | |A
975+
b | text | | extended | |B
976976
Check constraints:
977977
"t1_a_check" CHECK (length(a) > 2)
978978
Inherits: t1
@@ -987,12 +987,12 @@ SELECT description FROM pg_description, pg_constraint c WHERE classoid = 'pg_con
987987
CREATE TABLE t13_inh () INHERITS (t1, t3);
988988
NOTICE: merging multiple inherited definitions of column "a"
989989
\d+ t13_inh
990-
Table "public.t13_inh"
991-
Column | Type | Modifiers | Storage | Description
992-
--------+------+-----------+----------+-------------
993-
a | text | not null | main |
994-
b | text | | extended |
995-
c | text | | external |
990+
Table "public.t13_inh"
991+
Column | Type | Modifiers | Storage |Stats target |Description
992+
--------+------+-----------+----------+--------------+-------------
993+
a | text | not null | main | |
994+
b | text | | extended | |
995+
c | text | | external | |
996996
Check constraints:
997997
"t1_a_check" CHECK (length(a) > 2)
998998
"t3_a_check" CHECK (length(a) < 5)
@@ -1003,12 +1003,12 @@ Has OIDs: no
10031003
CREATE TABLE t13_like (LIKE t3 INCLUDING CONSTRAINTS INCLUDING COMMENTS INCLUDING STORAGE) INHERITS (t1);
10041004
NOTICE: merging column "a" with inherited definition
10051005
\d+ t13_like
1006-
Table "public.t13_like"
1007-
Column | Type | Modifiers | Storage | Description
1008-
--------+------+-----------+----------+-------------
1009-
a | text | not null | main | A3
1010-
b | text | | extended |
1011-
c | text | | external | C
1006+
Table "public.t13_like"
1007+
Column | Type | Modifiers | Storage |Stats target |Description
1008+
--------+------+-----------+----------+--------------+-------------
1009+
a | text | not null | main | |A3
1010+
b | text | | extended | |
1011+
c | text | | external | |C
10121012
Check constraints:
10131013
"t1_a_check" CHECK (length(a) > 2)
10141014
"t3_a_check" CHECK (length(a) < 5)
@@ -1024,11 +1024,11 @@ SELECT description FROM pg_description, pg_constraint c WHERE classoid = 'pg_con
10241024
CREATE TABLE t_all (LIKE t1 INCLUDING ALL);
10251025
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t_all_pkey" for table "t_all"
10261026
\d+ t_all
1027-
Table "public.t_all"
1028-
Column | Type | Modifiers | Storage | Description
1029-
--------+------+-----------+----------+-------------
1030-
a | text | not null | main | A
1031-
b | text | | extended | B
1027+
Table "public.t_all"
1028+
Column | Type | Modifiers | Storage |Stats target |Description
1029+
--------+------+-----------+----------+--------------+-------------
1030+
a | text | not null | main | |A
1031+
b | text | | extended | |B
10321032
Indexes:
10331033
"t_all_pkey" PRIMARY KEY, btree (a)
10341034
"t_all_b_idx" btree (b)
@@ -1065,13 +1065,13 @@ ALTER TABLE ts RENAME aa TO aaa; -- to be failed
10651065
ERROR: cannot rename inherited column "aa"
10661066
ALTER TABLE ts RENAME d TO dd;
10671067
\d+ ts
1068-
Table "public.ts"
1069-
Column | Type | Modifiers | Storage | Description
1070-
--------+---------+-----------+---------+-------------
1071-
aa | integer | | plain |
1072-
b | integer | | plain |
1073-
c | integer | | plain |
1074-
dd | integer | | plain |
1068+
Table "public.ts"
1069+
Column | Type | Modifiers | Storage |Stats target |Description
1070+
--------+---------+-----------+---------+--------------+-------------
1071+
aa | integer | | plain | |
1072+
b | integer | | plain | |
1073+
c | integer | | plain | |
1074+
dd | integer | | plain | |
10751075
Inherits: t1,
10761076
s1
10771077
Has OIDs: no
@@ -1085,14 +1085,14 @@ NOTICE: merging multiple inherited definitions of column "aa"
10851085
NOTICE: merging multiple inherited definitions of column "b"
10861086
ALTER TABLE t1 RENAME aa TO aaa;
10871087
\d+ t4
1088-
Table "public.t4"
1089-
Column | Type | Modifiers | Storage | Description
1090-
--------+---------+-----------+---------+-------------
1091-
aaa | integer | | plain |
1092-
b | integer | | plain |
1093-
x | integer | | plain |
1094-
y | integer | | plain |
1095-
z | integer | | plain |
1088+
Table "public.t4"
1089+
Column | Type | Modifiers | Storage |Stats target |Description
1090+
--------+---------+-----------+---------+--------------+-------------
1091+
aaa | integer | | plain | |
1092+
b | integer | | plain | |
1093+
x | integer | | plain | |
1094+
y | integer | | plain | |
1095+
z | integer | | plain | |
10961096
Inherits: t2,
10971097
t3
10981098
Has OIDs: no
@@ -1103,14 +1103,14 @@ ALTER TABLE t1 RENAME aaa TO aaaa;
11031103
ALTER TABLE t1 RENAME b TO bb; -- to be failed
11041104
ERROR: cannot rename inherited column "b"
11051105
\d+ ts
1106-
Table "public.ts"
1107-
Column | Type | Modifiers | Storage | Description
1108-
--------+---------+-----------+---------+-------------
1109-
aaaa | integer | | plain |
1110-
b | integer | | plain |
1111-
x | integer | | plain |
1112-
c | integer | | plain |
1113-
d | integer | | plain |
1106+
Table "public.ts"
1107+
Column | Type | Modifiers | Storage |Stats target |Description
1108+
--------+---------+-----------+---------+--------------+-------------
1109+
aaaa | integer | | plain | |
1110+
b | integer | | plain | |
1111+
x | integer | | plain | |
1112+
c | integer | | plain | |
1113+
d | integer | | plain | |
11141114
Inherits: t2,
11151115
s1
11161116
Has OIDs: no

0 commit comments

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