aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2017-03-25 17:25:28 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2017-03-25 17:25:28 -0400
commit2cdc1389a25bc62b36a6f83d5d095acb99e3277c (patch)
tree3c18e123d2265573252a374db1a01d8079445df5
parentcf366e97ff2f74663754085ee2386bbee39b3edf (diff)
downloadpostgresql-2cdc1389a25bc62b36a6f83d5d095acb99e3277c.tar.gz
postgresql-2cdc1389a25bc62b36a6f83d5d095acb99e3277c.zip
Remember to drop roles created by regression tests.
Commit e3920ac82 created "regress_subscription_user2" in subscription.sql, but forgot to drop it, causing the regression tests to fail if run twice without re-initdb'ing.
-rw-r--r--src/test/regress/expected/subscription.out1
-rw-r--r--src/test/regress/sql/subscription.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/subscription.out b/src/test/regress/expected/subscription.out
index 41f8def2f7f..8760d5970aa 100644
--- a/src/test/regress/expected/subscription.out
+++ b/src/test/regress/expected/subscription.out
@@ -119,4 +119,5 @@ DROP SUBSCRIPTION testsub NODROP SLOT; -- fail
ERROR: subscription "testsub" does not exist
RESET SESSION AUTHORIZATION;
DROP ROLE regress_subscription_user;
+DROP ROLE regress_subscription_user2;
DROP ROLE regress_subscription_user_dummy;
diff --git a/src/test/regress/sql/subscription.sql b/src/test/regress/sql/subscription.sql
index 2db97db2f51..7bdc2b3503c 100644
--- a/src/test/regress/sql/subscription.sql
+++ b/src/test/regress/sql/subscription.sql
@@ -92,4 +92,5 @@ DROP SUBSCRIPTION testsub NODROP SLOT; -- fail
RESET SESSION AUTHORIZATION;
DROP ROLE regress_subscription_user;
+DROP ROLE regress_subscription_user2;
DROP ROLE regress_subscription_user_dummy;