Fix the test output

PJMODOS · PJMODOS · commit 5df29c313220 · 2016-01-16T09:41:57.000+01:00
diff --git a/expected/bidirectional.out b/expected/bidirectional.out
@@ -108,22 +108,33 @@ NOTICE:  drop cascades to 1 other object
  t
 (1 row)
 
+SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
+                 slot_name                  
+--------------------------------------------
+ pgl_postgres_test_provider_test_sube55bf37
+(1 row)
+
+SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
+ count 
+-------
+     1
+(1 row)
+
 SELECT pglogical.drop_subscription('test_bidirectional');
  drop_subscription 
 -------------------
                  1
 (1 row)
 
 \c :subscriber_dsn
-SELECT count(1) FROM pg_stat_replication;
+SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
+ slot_name 
+-----------
+(0 rows)
+
+SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
  count 
 -------
-     1
-(1 row)
-
-SELECT slot_name FROM pg_replication_slots;
-                 slot_name                  
---------------------------------------------
- pgl_postgres_test_provider_test_sube55bf37
+     0
 (1 row)
 
diff --git a/sql/bidirectional.sql b/sql/bidirectional.sql
@@ -65,9 +65,12 @@ SELECT pglogical.replicate_ddl_command($$
     DROP TABLE public.basic_dml CASCADE;
 $$);
 
+SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
+SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
+
 SELECT pglogical.drop_subscription('test_bidirectional');
 
 \c :subscriber_dsn
 
-SELECT count(1) FROM pg_stat_replication;
-SELECT slot_name FROM pg_replication_slots;
+SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
+SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
