X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=openerpcommand%2Fdrop.py;h=b64442716defc9f6cf877f80aedc5844aed1949c;hb=211f3b74b82333972e57ec3c9d4f7c5f38e358cd;hp=aee8c2859f98809929af932e5273580bb8b5285d;hpb=3da57500c279cd19fa6d561eef149d708383138d;p=odoo%2Fodoo.git

diff --git a/openerpcommand/drop.py b/openerpcommand/drop.py
index aee8c28..b644427 100644
--- a/openerpcommand/drop.py
+++ b/openerpcommand/drop.py
@@ -9,6 +9,7 @@ import common
 # openerp/service/web_services.py).
 def drop_database(database_name):
     import openerp
+    openerp.netsvc.init_logger()
     db = openerp.sql_db.db_connect('template1')
     cr = db.cursor()
     cr.autocommit(True) # avoid transaction block
@@ -16,17 +17,21 @@ def drop_database(database_name):
         # TODO option for doing this.
         # Try to terminate all other connections that might prevent
         # dropping the database
+
+        # PostgreSQL 9.2 renamed pg_stat_activity.procpid to pid:
+        # http://www.postgresql.org/docs/9.2/static/release-9-2.html#AEN110389
+        pid_col = 'pid' if cr._cnx.server_version >= 90200 else 'procpid'
         try:
-            cr.execute("""SELECT pg_terminate_backend(procpid)
+            cr.execute("""SELECT pg_terminate_backend(%(pid_col)s)
                           FROM pg_stat_activity
-                          WHERE datname = %s AND 
-                                procpid != pg_backend_pid()""",
+                          WHERE datname = %%s AND 
+                                %(pid_col)s != pg_backend_pid()""" % {'pid_col': pid_col},
                        (database_name,))
         except Exception:
             pass
 
         try:
-            cr.execute('DROP DATABASE "%s"' % database_name)
+            cr.execute('DROP DATABASE "%s"' % database_name, log_exceptions=False)
         except Exception, e:
             print "Can't drop %s" % (database_name,)
     finally: