More test output optimization

PJMODOS · PJMODOS · commit 8de7fe612faf · 2016-01-16T09:08:37.000+01:00
diff --git a/expected/drop.out b/expected/drop.out
@@ -4,10 +4,10 @@ SELECT * FROM pglogical_regress_variables()
 SELECT * FROM pglogical.drop_node(node_name := 'test_provider');
 ERROR:  cannot drop node "test_provider" because replication slot "pgl_postgres_test_provider_test_sube55bf37" on the node is still active
 HINT:  drop the subscriptions first
-SELECT slot_name, plugin, slot_type, database, active FROM pg_replication_slots;
-                 slot_name                  |      plugin      | slot_type |  database  | active 
---------------------------------------------+------------------+-----------+------------+--------
- pgl_postgres_test_provider_test_sube55bf37 | pglogical_output | logical   | regression | t
+SELECT plugin, slot_type, active FROM pg_replication_slots;
+      plugin      | slot_type | active 
+------------------+-----------+--------
+ pglogical_output | logical   | t
 (1 row)
 
 SELECT count(*) FROM pg_stat_replication;
@@ -36,9 +36,9 @@ SELECT * FROM pglogical.drop_node(node_name := 'test_provider');
  t
 (1 row)
 
-SELECT slot_name, plugin, slot_type, database, active FROM pg_replication_slots;
- slot_name | plugin | slot_type | database | active 
------------+--------+-----------+----------+--------
+SELECT plugin, slot_type, active FROM pg_replication_slots;
+ plugin | slot_type | active 
+--------+-----------+--------
 (0 rows)
 
 SELECT count(*) FROM pg_stat_replication;
diff --git a/sql/drop.sql b/sql/drop.sql
@@ -5,7 +5,7 @@ SELECT * FROM pglogical_regress_variables()
 \c :provider_dsn
 SELECT * FROM pglogical.drop_node(node_name := 'test_provider');
 
-SELECT slot_name, plugin, slot_type, database, active FROM pg_replication_slots;
+SELECT plugin, slot_type, active FROM pg_replication_slots;
 SELECT count(*) FROM pg_stat_replication;
 
 \c :subscriber_dsn
@@ -15,5 +15,5 @@ SELECT * FROM pglogical.drop_node(node_name := 'test_subscriber');
 \c :provider_dsn
 SELECT * FROM pglogical.drop_node(node_name := 'test_provider');
 
-SELECT slot_name, plugin, slot_type, database, active FROM pg_replication_slots;
+SELECT plugin, slot_type, active FROM pg_replication_slots;
 SELECT count(*) FROM pg_stat_replication;
