aboutsummaryrefslogtreecommitdiff
path: root/src/bin/scripts/dropuser.c
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2011-12-06 08:48:15 -0500
committerRobert Haas <rhaas@postgresql.org>2011-12-06 08:48:15 -0500
commit68281e00540a29e7f9bfc154c25a78b875f560d1 (patch)
treeedd65f9661d0efcdc11780cea0466c1f8aeb6715 /src/bin/scripts/dropuser.c
parent6ef4ae1d4e829675c332c39895fdf90e15c3faeb (diff)
downloadpostgresql-68281e00540a29e7f9bfc154c25a78b875f560d1.tar.gz
postgresql-68281e00540a29e7f9bfc154c25a78b875f560d1.zip
Make command-line tools smarter about finding a DB to connect to.
If unable to connect to "postgres", try "template1". This allows things to work more smoothly in the case where the postgres database has been dropped. And just in case that's not good enough, also allow the user to specify a maintenance database to be used for the initial connection, to cover the case where neither postgres nor template1 is suitable.
Diffstat (limited to 'src/bin/scripts/dropuser.c')
-rw-r--r--src/bin/scripts/dropuser.c3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/bin/scripts/dropuser.c b/src/bin/scripts/dropuser.c
index bfd5b1cfd5a..f67fb0bcb8f 100644
--- a/src/bin/scripts/dropuser.c
+++ b/src/bin/scripts/dropuser.c
@@ -119,7 +119,8 @@ main(int argc, char *argv[])
appendPQExpBuffer(&sql, "DROP ROLE %s%s;\n",
(if_exists ? "IF EXISTS " : ""), fmtId(dropuser));
- conn = connectDatabase("postgres", host, port, username, prompt_password, progname);
+ conn = connectDatabase("postgres", host, port, username, prompt_password,
+ progname, false);
if (echo)
printf("%s", sql.data);