fix #4832: also consider schema in geometry_columns/geography columns

jef-n · jef-n · commit db950895cd24 · 2012-01-17T22:33:53.000+01:00
diff --git a/src/providers/postgres/qgspostgresconn.cpp b/src/providers/postgres/qgspostgresconn.cpp
@@ -333,7 +333,12 @@ bool QgsPostgresConn::getTableInfo( bool searchGeometryColumnsOnly, bool searchP
                            " AND pg_namespace.oid=pg_class.relnamespace"
                            " AND has_schema_privilege(pg_namespace.nspname,'usage')"
                            " AND has_table_privilege('\"'||pg_namespace.nspname||'\".\"'||pg_class.relname||'\"','select')" // user has select privilege
-                           " ORDER BY f_table_schema,f_table_name,%2" ).arg( gtableName ).arg( columnName );
+                         ).arg( gtableName ).arg( columnName );
+
+    if ( searchPublicOnly )
+      sql += " AND f_table_schema='public'";
+
+    sql += QString( " ORDER BY f_table_schema,f_table_name,%1" ).arg( columnName );
 
     QgsDebugMsg( "getting table info: " + sql );
     result = PQexec( sql, i == 0 );
