File tree Expand file tree Collapse file tree 2 files changed +5
-23
lines changed Expand file tree Collapse file tree 2 files changed +5
-23
lines changed Original file line number Diff line number Diff line change @@ -108,33 +108,18 @@ NOTICE: drop cascades to 1 other object
108
108
t
109
109
(1 row)
110
110
111
- SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
112
- slot_name
113
- --------------------------------------------
114
- pgl_postgres_test_provider_test_sube55bf37
115
- (1 row)
116
-
117
- SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
118
- count
119
- -------
120
- 1
121
- (1 row)
122
-
123
111
SELECT pglogical.drop_subscription('test_bidirectional');
124
112
drop_subscription
125
113
-------------------
126
114
1
127
115
(1 row)
128
116
129
117
\c :subscriber_dsn
118
+ \a
130
119
SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
131
- slot_name
132
- -----------
120
+ slot_name
133
121
(0 rows)
134
-
135
122
SELECT count(*) FROM pg_stat_replication WHERE application_name = 'test_bidirectional';
136
- count
137
- -------
138
- 0
123
+ count
124
+ 0
139
125
(1 row)
140
-
Original file line number Diff line number Diff line change @@ -65,12 +65,9 @@ SELECT pglogical.replicate_ddl_command($$
65
65
DROP TABLE public .basic_dml CASCADE;
66
66
$$);
67
67
68
- SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
69
- SELECT count (* ) FROM pg_stat_replication WHERE application_name = ' test_bidirectional' ;
70
-
71
68
SELECT pglogical .drop_subscription (' test_bidirectional' );
72
69
73
70
\c :subscriber_dsn
74
-
71
+ \a
75
72
SELECT slot_name FROM pg_replication_slots WHERE database = current_database();
76
73
SELECT count (* ) FROM pg_stat_replication WHERE application_name = ' test_bidirectional' ;
You can’t perform that action at this time.
0 commit comments