# HG changeset patch # User Christopher Springer # Date 1440157201 -3600 # Node ID b217dc3b654a98bee5e86f4b05a1ac063167d221 # Parent e721a977726be5a2185142965c452db4ee021d14 USASR-1835: Attempt to fix quoting of database name in sql diff -r e721a977726b -r b217dc3b654a init20.gradle --- a/init20.gradle Fri Aug 21 12:32:03 2015 +0100 +++ b/init20.gradle Fri Aug 21 12:40:01 2015 +0100 @@ -298,8 +298,8 @@ driverName) if (dropIt) { logger.info "disconnecting sessions from $databaseName" - sql.execute "REVOKE CONNECT ON DATABASE " + databaseName + " FROM public;" - sql.execute "REVOKE CONNECT ON DATABASE " + databaseName + " FROM " + gradle.environmentDatabase.jdbc.username + ";" + sql.execute "REVOKE CONNECT ON DATABASE \"" + databaseName + "\" FROM public;" + sql.execute "REVOKE CONNECT ON DATABASE \"" + databaseName + "\" FROM " + gradle.environmentDatabase.jdbc.username + ";" sql.execute "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '" + databaseName + "';" logger.info "dropping $databaseName (if exists) from $adminUrl" sql.execute 'DROP DATABASE IF EXISTS "' + databaseName + '";'