fix #1987

jef · jef · commit 5920feb425d2 · 2009-10-09T13:06:15.000Z
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@11784 c8812cc2-4d05-0410-92ff-de0c093fc19c
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 + "'" );
