fix #1897

git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@11514 c8812cc2-4d05-0410-92ff-de0c093fc19c
qgis · Aug 26, 2009 · 2ad0d87 · 2ad0d87
1 parent 757a4e3
commit 2ad0d87
Show file tree

Hide file tree

Showing 3 changed files with 1 addition and 5 deletions.
diff --git a/src/app/qgsnewconnection.cpp b/src/app/qgsnewconnection.cpp
@@ -15,7 +15,6 @@
  *                                                                         *
  ***************************************************************************/
 /* $Id$ */
-#include <iostream>
 
 #include <QSettings>
 #include <QMessageBox>
@@ -132,8 +131,6 @@ void QgsNewConnection::testConnection()
   }
   // free pg connection resources
   PQfinish( pd );
-
-
 }
 
 void QgsNewConnection::saveConnection()

diff --git a/src/plugins/spit/qgsspit.cpp b/src/plugins/spit/qgsspit.cpp
@@ -467,7 +467,7 @@ void QgsSpit::dbConnect()
       }
     }
 
-    QString schemaSql = QString( "select nspname from pg_namespace,pg_user where nspowner=usesysid and usename=%1" )
+    QString schemaSql = QString( "select nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')" )
                         .arg( QgsPgUtil::quotedValue( username ) );
     PGresult *schemas = PQexec( conn, schemaSql.toUtf8() );
     // get the schema names

diff --git a/src/plugins/spit/qgsspitplugin.cpp b/src/plugins/spit/qgsspitplugin.cpp
@@ -19,7 +19,6 @@
 /*  $Id$ */
 
 // includes
-#include <iostream>
 #include <vector>
 
 #include <QAction>