aboutsummaryrefslogtreecommitdiff
path: root/src/bin/scripts/t/090_reindexdb.pl
diff options
context:
space:
mode:
Diffstat (limited to 'src/bin/scripts/t/090_reindexdb.pl')
-rw-r--r--src/bin/scripts/t/090_reindexdb.pl14
1 files changed, 14 insertions, 0 deletions
diff --git a/src/bin/scripts/t/090_reindexdb.pl b/src/bin/scripts/t/090_reindexdb.pl
index 4f1a1411320..429dd3acd68 100644
--- a/src/bin/scripts/t/090_reindexdb.pl
+++ b/src/bin/scripts/t/090_reindexdb.pl
@@ -262,4 +262,18 @@ $node->command_ok(
[ 'reindexdb', '-j', '2', '--concurrently', '-d', 'postgres' ],
'parallel reindexdb on database, concurrently');
+# combinations of objects
+$node->issues_sql_like(
+ [ 'reindexdb', '-s', '-t', 'test1', 'postgres' ],
+ qr/statement:\ REINDEX SYSTEM postgres;/,
+ 'specify both --system and --table');
+$node->issues_sql_like(
+ [ 'reindexdb', '-s', '-i', 'test1x', 'postgres' ],
+ qr/statement:\ REINDEX INDEX public.test1x;/,
+ 'specify both --system and --index');
+$node->issues_sql_like(
+ [ 'reindexdb', '-s', '-S', 'pg_catalog', 'postgres' ],
+ qr/statement:\ REINDEX SCHEMA pg_catalog;/,
+ 'specify both --system and --schema');
+
done_testing();