Skip to content

Commit 44d88c6

Browse files
funbringerfunbringer
committed
use \set VERBOSITY terse
1 parent c67196d commit 44d88c6

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
CREATE SCHEMA callbacks;
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
CREATE SCHEMA domains;
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
CREATE SCHEMA fkeys;
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
CREATE SCHEMA pathman;
24
CREATE EXTENSION pg_pathman SCHEMA pathman;
35
CREATE SCHEMA test;

0 commit comments

Comments
 (0)