fix #1987

git-svn-id: http://svn.osgeo.org/qgis/trunk@11784 c8812cc2-4d05-0410-92ff-de0c093fc19c
qgis · Oct 9, 2009 · 9037374 · 9037374
1 parent 048421a
commit 9037374
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -974,7 +974,7 @@ QString QgsPostgresProvider::getPrimaryKey()
   // can be used as a key into the table. Primary keys are always
   // unique indices, so we catch them as well.
 
-  QString sql = QString( "select indkey from pg_index where indisunique='t' and indrelid=regclass(%1)::oid" )
+  QString sql = QString( "select indkey from pg_index where indisunique and indrelid=regclass(%1)::oid and indpred is null" )
                 .arg( quotedValue( mSchemaTableName ) );
 
   QgsDebugMsg( "Getting unique index using '" + sql + "'" );