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

Commit44d88c6

Browse files
committed
use \set VERBOSITY terse
1 parentc67196d commit44d88c6

12 files changed

+16
-124
lines changed

‎expected/pathman_callbacks.out

Lines changed: 1 addition & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA callbacks;
34
/* Check callbacks */
@@ -99,14 +100,4 @@ WARNING: callback: partition "abc_4"
99100

100101
DROP SCHEMA callbacks CASCADE;
101102
NOTICE: drop cascades to 10 other objects
102-
DETAIL: drop cascades to table callbacks.log
103-
drop cascades to function callbacks.abc_on_part_created_range_callback(jsonb)
104-
drop cascades to function callbacks.abc_on_part_created_hash_callback(jsonb)
105-
drop cascades to table callbacks.abc
106-
drop cascades to sequence callbacks.abc_seq
107-
drop cascades to table callbacks.abc_0
108-
drop cascades to table callbacks.abc_1
109-
drop cascades to table callbacks.abc_2
110-
drop cascades to table callbacks.abc_3
111-
drop cascades to table callbacks.abc_4
112103
DROP EXTENSION pg_pathman CASCADE;

‎expected/pathman_domains.out

Lines changed: 1 addition & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA domains;
34
CREATE DOMAIN domains.dom_test AS numeric CHECK (value < 1200);
@@ -88,21 +89,4 @@ ORDER BY range_min::INT, range_max::INT;
8889

8990
DROP SCHEMA domains CASCADE;
9091
NOTICE: drop cascades to 17 other objects
91-
DETAIL: drop cascades to type domains.dom_test
92-
drop cascades to table domains.dom_table
93-
drop cascades to sequence domains.dom_table_seq
94-
drop cascades to table domains.dom_table_1
95-
drop cascades to table domains.dom_table_3
96-
drop cascades to table domains.dom_table_4
97-
drop cascades to table domains.dom_table_5
98-
drop cascades to table domains.dom_table_6
99-
drop cascades to table domains.dom_table_7
100-
drop cascades to table domains.dom_table_8
101-
drop cascades to table domains.dom_table_9
102-
drop cascades to table domains.dom_table_10
103-
drop cascades to table domains.dom_table_11
104-
drop cascades to table domains.dom_table_12
105-
drop cascades to table domains.dom_table_13
106-
drop cascades to table domains.dom_table_14
107-
drop cascades to table domains.dom_table_15
10892
DROP EXTENSION pg_pathman CASCADE;

‎expected/pathman_foreign_keys.out

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA fkeys;
34
/* Check primary keys generation */
@@ -17,7 +18,6 @@ NOTICE: sequence "test_fkey_seq" does not exist, skipping
1718

1819
INSERT INTO fkeys.test_fkey VALUES(1, 'wrong');
1920
ERROR: insert or update on table "test_fkey_1" violates foreign key constraint "test_fkey_1_comment_fkey"
20-
DETAIL: Key (comment)=(wrong) is not present in table "test_ref".
2121
INSERT INTO fkeys.test_fkey VALUES(1, 'test');
2222
SELECT drop_partitions('fkeys.test_fkey');
2323
NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping
@@ -44,7 +44,6 @@ SELECT create_hash_partitions('fkeys.test_fkey', 'id', 10);
4444

4545
INSERT INTO fkeys.test_fkey VALUES(1, 'wrong');
4646
ERROR: insert or update on table "test_fkey_0" violates foreign key constraint "test_fkey_0_comment_fkey"
47-
DETAIL: Key (comment)=(wrong) is not present in table "test_ref".
4847
INSERT INTO fkeys.test_fkey VALUES(1, 'test');
4948
SELECT drop_partitions('fkeys.test_fkey');
5049
NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping
@@ -65,7 +64,4 @@ NOTICE: 94 rows copied from fkeys.test_fkey_9
6564

6665
DROP SCHEMA fkeys CASCADE;
6766
NOTICE: drop cascades to 3 other objects
68-
DETAIL: drop cascades to table fkeys.test_ref
69-
drop cascades to table fkeys.test_fkey
70-
drop cascades to sequence fkeys.test_fkey_seq
7167
DROP EXTENSION pg_pathman CASCADE;

‎expected/pathman_runtime_nodes.out

Lines changed: 1 addition & 30 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE SCHEMA pathman;
23
CREATE EXTENSION pg_pathman SCHEMA pathman;
34
CREATE SCHEMA test;
@@ -286,35 +287,5 @@ select test.pathman_test_5(); /* projection tests for RuntimeXXX nodes */
286287

287288
DROP SCHEMA test CASCADE;
288289
NOTICE: drop cascades to 30 other objects
289-
DETAIL: drop cascades to function test.pathman_assert(boolean,text)
290-
drop cascades to function test.pathman_equal(text,text,text)
291-
drop cascades to function test.pathman_test(text)
292-
drop cascades to function test.pathman_test_1()
293-
drop cascades to function test.pathman_test_2()
294-
drop cascades to function test.pathman_test_3()
295-
drop cascades to function test.pathman_test_4()
296-
drop cascades to function test.pathman_test_5()
297-
drop cascades to table test.run_values
298-
drop cascades to table test.runtime_test_1
299-
drop cascades to table test.runtime_test_1_0
300-
drop cascades to table test.runtime_test_1_1
301-
drop cascades to table test.runtime_test_1_2
302-
drop cascades to table test.runtime_test_1_3
303-
drop cascades to table test.runtime_test_1_4
304-
drop cascades to table test.runtime_test_1_5
305-
drop cascades to table test.category
306-
drop cascades to table test.runtime_test_2
307-
drop cascades to table test.runtime_test_2_0
308-
drop cascades to table test.runtime_test_2_1
309-
drop cascades to table test.runtime_test_2_2
310-
drop cascades to table test.runtime_test_2_3
311-
drop cascades to table test.runtime_test_2_4
312-
drop cascades to table test.runtime_test_2_5
313-
drop cascades to table test.vals
314-
drop cascades to table test.runtime_test_3
315-
drop cascades to table test.runtime_test_3_0
316-
drop cascades to table test.runtime_test_3_1
317-
drop cascades to table test.runtime_test_3_2
318-
drop cascades to table test.runtime_test_3_3
319290
DROP EXTENSION pg_pathman CASCADE;
320291
DROP SCHEMA pathman CASCADE;

‎results/pathman_callbacks.out

Lines changed: 1 addition & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA callbacks;
34
/* Check callbacks */
@@ -99,14 +100,4 @@ WARNING: callback: partition "abc_4"
99100

100101
DROP SCHEMA callbacks CASCADE;
101102
NOTICE: drop cascades to 10 other objects
102-
DETAIL: drop cascades to table callbacks.log
103-
drop cascades to function callbacks.abc_on_part_created_range_callback(jsonb)
104-
drop cascades to function callbacks.abc_on_part_created_hash_callback(jsonb)
105-
drop cascades to table callbacks.abc
106-
drop cascades to sequence callbacks.abc_seq
107-
drop cascades to table callbacks.abc_0
108-
drop cascades to table callbacks.abc_1
109-
drop cascades to table callbacks.abc_2
110-
drop cascades to table callbacks.abc_3
111-
drop cascades to table callbacks.abc_4
112103
DROP EXTENSION pg_pathman CASCADE;

‎results/pathman_domains.out

Lines changed: 1 addition & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA domains;
34
CREATE DOMAIN domains.dom_test AS numeric CHECK (value < 1200);
@@ -88,21 +89,4 @@ ORDER BY range_min::INT, range_max::INT;
8889

8990
DROP SCHEMA domains CASCADE;
9091
NOTICE: drop cascades to 17 other objects
91-
DETAIL: drop cascades to type domains.dom_test
92-
drop cascades to table domains.dom_table
93-
drop cascades to sequence domains.dom_table_seq
94-
drop cascades to table domains.dom_table_1
95-
drop cascades to table domains.dom_table_3
96-
drop cascades to table domains.dom_table_4
97-
drop cascades to table domains.dom_table_5
98-
drop cascades to table domains.dom_table_6
99-
drop cascades to table domains.dom_table_7
100-
drop cascades to table domains.dom_table_8
101-
drop cascades to table domains.dom_table_9
102-
drop cascades to table domains.dom_table_10
103-
drop cascades to table domains.dom_table_11
104-
drop cascades to table domains.dom_table_12
105-
drop cascades to table domains.dom_table_13
106-
drop cascades to table domains.dom_table_14
107-
drop cascades to table domains.dom_table_15
10892
DROP EXTENSION pg_pathman CASCADE;

‎results/pathman_foreign_keys.out

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE EXTENSION pg_pathman;
23
CREATE SCHEMA fkeys;
34
/* Check primary keys generation */
@@ -17,7 +18,6 @@ NOTICE: sequence "test_fkey_seq" does not exist, skipping
1718

1819
INSERT INTO fkeys.test_fkey VALUES(1, 'wrong');
1920
ERROR: insert or update on table "test_fkey_1" violates foreign key constraint "test_fkey_1_comment_fkey"
20-
DETAIL: Key (comment)=(wrong) is not present in table "test_ref".
2121
INSERT INTO fkeys.test_fkey VALUES(1, 'test');
2222
SELECT drop_partitions('fkeys.test_fkey');
2323
NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping
@@ -44,7 +44,6 @@ SELECT create_hash_partitions('fkeys.test_fkey', 'id', 10);
4444

4545
INSERT INTO fkeys.test_fkey VALUES(1, 'wrong');
4646
ERROR: insert or update on table "test_fkey_0" violates foreign key constraint "test_fkey_0_comment_fkey"
47-
DETAIL: Key (comment)=(wrong) is not present in table "test_ref".
4847
INSERT INTO fkeys.test_fkey VALUES(1, 'test');
4948
SELECT drop_partitions('fkeys.test_fkey');
5049
NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping
@@ -65,7 +64,4 @@ NOTICE: 94 rows copied from fkeys.test_fkey_9
6564

6665
DROP SCHEMA fkeys CASCADE;
6766
NOTICE: drop cascades to 3 other objects
68-
DETAIL: drop cascades to table fkeys.test_ref
69-
drop cascades to table fkeys.test_fkey
70-
drop cascades to sequence fkeys.test_fkey_seq
7167
DROP EXTENSION pg_pathman CASCADE;

‎results/pathman_runtime_nodes.out

Lines changed: 1 addition & 30 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
\set VERBOSITY terse
12
CREATE SCHEMA pathman;
23
CREATE EXTENSION pg_pathman SCHEMA pathman;
34
CREATE SCHEMA test;
@@ -286,35 +287,5 @@ select test.pathman_test_5(); /* projection tests for RuntimeXXX nodes */
286287

287288
DROP SCHEMA test CASCADE;
288289
NOTICE: drop cascades to 30 other objects
289-
DETAIL: drop cascades to function test.pathman_assert(boolean,text)
290-
drop cascades to function test.pathman_equal(text,text,text)
291-
drop cascades to function test.pathman_test(text)
292-
drop cascades to function test.pathman_test_1()
293-
drop cascades to function test.pathman_test_2()
294-
drop cascades to function test.pathman_test_3()
295-
drop cascades to function test.pathman_test_4()
296-
drop cascades to function test.pathman_test_5()
297-
drop cascades to table test.run_values
298-
drop cascades to table test.runtime_test_1
299-
drop cascades to table test.runtime_test_1_0
300-
drop cascades to table test.runtime_test_1_1
301-
drop cascades to table test.runtime_test_1_2
302-
drop cascades to table test.runtime_test_1_3
303-
drop cascades to table test.runtime_test_1_4
304-
drop cascades to table test.runtime_test_1_5
305-
drop cascades to table test.category
306-
drop cascades to table test.runtime_test_2
307-
drop cascades to table test.runtime_test_2_0
308-
drop cascades to table test.runtime_test_2_1
309-
drop cascades to table test.runtime_test_2_2
310-
drop cascades to table test.runtime_test_2_3
311-
drop cascades to table test.runtime_test_2_4
312-
drop cascades to table test.runtime_test_2_5
313-
drop cascades to table test.vals
314-
drop cascades to table test.runtime_test_3
315-
drop cascades to table test.runtime_test_3_0
316-
drop cascades to table test.runtime_test_3_1
317-
drop cascades to table test.runtime_test_3_2
318-
drop cascades to table test.runtime_test_3_3
319290
DROP EXTENSION pg_pathman CASCADE;
320291
DROP SCHEMA pathman CASCADE;

‎sql/pathman_callbacks.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,5 @@
1+
\set VERBOSITY terse
2+
13
CREATE EXTENSION pg_pathman;
24
CREATESCHEMAcallbacks;
35

‎sql/pathman_domains.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,5 @@
1+
\set VERBOSITY terse
2+
13
CREATE EXTENSION pg_pathman;
24
CREATESCHEMAdomains;
35

‎sql/pathman_foreign_keys.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,5 @@
1+
\set VERBOSITY terse
2+
13
CREATE EXTENSION pg_pathman;
24
CREATESCHEMAfkeys;
35

‎sql/pathman_runtime_nodes.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,5 @@
1+
\set VERBOSITY terse
2+
13
CREATESCHEMApathman;
24
CREATE EXTENSION pg_pathman SCHEMA pathman;
35
CREATESCHEMAtest;

0 commit comments

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