From 185620bb3fe891fa6e074555f256df4bb2c58c63 Mon Sep 17 00:00:00 2001
From: Manuel Barkhau <mb@nexttuesday.de>
Date: Wed, 21 Sep 2016 19:24:21 +0200
Subject: fixes #588 invalid setting for redshift

---
 pgcli/pgexecute.py | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/pgcli/pgexecute.py b/pgcli/pgexecute.py
index a02ae6c5..3e5d15e6 100644
--- a/pgcli/pgexecute.py
+++ b/pgcli/pgexecute.py
@@ -164,7 +164,6 @@ class PGExecute(object):
         port = (port or self.port)
         dsn = (dsn or self.dsn)
         pid = -1
-        superuser = False
         if dsn:
             if password:
                 dsn = "{0} password={1}".format(dsn, password)
@@ -186,7 +185,9 @@ class PGExecute(object):
 
             cursor = conn.cursor()
 
-        superuser = self._select_one(cursor, "select current_setting('is_superuser')::bool")[0]
+        cursor.execute("SHOW ALL")
+        db_parameters = dict(cursor.fetchall())
+
         pid = self._select_one(cursor, 'select pg_backend_pid()')[0]
         conn.set_client_encoding('utf8')
         if hasattr(self, 'conn'):
@@ -199,7 +200,7 @@ class PGExecute(object):
         self.host = host
         self.port = port
         self.pid = pid
-        self.superuser = superuser
+        self.superuser = db_parameters.get('is_superuser') == '1'
 
         register_date_typecasters(conn)
         register_json_typecasters(self.conn, self._json_typecaster)
-- 
cgit v1.2.3