postgres
diff --git a/‎src/test/regress/expected/subscription.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/subscription.out
+4-2Lines changed: 4 additions & 2 deletions b/‎src/test/regress/expected/subscription.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/subscription.out
+4-2Lines changed: 4 additions & 2 deletions
diff --git a/‎src/test/regress/sql/subscription.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/subscription.sql
+4-2Lines changed: 4 additions & 2 deletions b/‎src/test/regress/sql/subscription.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/subscription.sql
+4-2Lines changed: 4 additions & 2 deletions
@@ -201,8 +201,10 @@ ALTER SUBSCRIPTION regress_testsub SET (slot_name = NONE);
 (1 row)
 
 DROP SUBSCRIPTION regress_testsub;
-CREATE SUBSCRIPTION regress_testsub CONNECTION 'dbname=postgres' PUBLICATION mypub
-       WITH (enabled = true, create_slot = false, copy_data = false);
+CREATE SUBSCRIPTION regress_testsub CONNECTION 'dbname=regress_doesnotexist' PUBLICATION mypub
+       WITH (connect = false, create_slot = false, copy_data = false);
+WARNING:  tables were not subscribed, you will have to run ALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables
+ALTER SUBSCRIPTION regress_testsub ENABLE;
 -- fail - ALTER SUBSCRIPTION with refresh is not allowed in a transaction
 -- block or function
 BEGIN;
 
@@ -147,8 +147,10 @@ ALTER SUBSCRIPTION regress_testsub SET (slot_name = NONE);
 
 DROP SUBSCRIPTION regress_testsub;
 
-CREATE SUBSCRIPTION regress_testsub CONNECTION 'dbname=postgres' PUBLICATION mypub
-       WITH (enabled = true, create_slot = false, copy_data = false);
+CREATE SUBSCRIPTION regress_testsub CONNECTION 'dbname=regress_doesnotexist' PUBLICATION mypub
+       WITH (connect = false, create_slot = false, copy_data = false);
+
+ALTER SUBSCRIPTION regress_testsub ENABLE;
 
 -- fail - ALTER SUBSCRIPTION with refresh is not allowed in a transaction
 -- block or function