Adjust the connection order to work around psycopg2 restriction.

1 files changed, 5 insertions, 4 deletions

diff --git a/pgcli/pgexecute.py b/pgcli/pgexecute.py
index 9c6167ef..650e7f5e 100644
--- a/pgcli/pgexecute.py
+++ b/pgcli/pgexecute.py
@@ -185,10 +185,6 @@ class PGExecute(object):
 
             cursor = conn.cursor()
 
-        cursor.execute("SHOW ALL")
-        db_parameters = dict(name_val_desc[:2] for name_val_desc in cursor.fetchall())
-
-        pid = self._select_one(cursor, 'select pg_backend_pid()')[0]
         conn.set_client_encoding('utf8')
         if hasattr(self, 'conn'):
             self.conn.close()
@@ -199,6 +195,11 @@ class PGExecute(object):
         self.password = password
         self.host = host
         self.port = port
+
+        cursor.execute("SHOW ALL")
+        db_parameters = dict(name_val_desc[:2] for name_val_desc in cursor.fetchall())
+
+        pid = self._select_one(cursor, 'select pg_backend_pid()')[0]
         self.pid = pid
         self.superuser = db_parameters.get('is_superuser') == '1'