Handling PostgreSQL <= 11.

qgis · Jun 2, 2020 · fef79a0 · fef79a0
1 parent 80f1e36
commit fef79a0
Showing 1 changed file with 8 additions and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -908,7 +908,14 @@ bool QgsPostgresProvider::loadFields()
         QString attGenerated = connectionRO()->pgVersion() >= 120000 ? fmtFieldTypeResult.PQgetvalue( i, 9 ) : " ";
         fmtFieldTypeMap[attrelid][attnum] = formatType;
         descrMap[attrelid][attnum] = descr;
-        defValMap[attrelid][attnum] = attGenerated.isEmpty() ? defVal : "DEFAULT";
+        if ( connectionRO()->pgVersion() >= 120000 )
+        {
+          defValMap[attrelid][attnum] = attGenerated.isEmpty() ? defVal : "DEFAULT";
+        }
+        else
+        {
+          defValMap[attrelid][attnum] = defVal;
+        }
         attTypeIdMap[attrelid][attnum] = attType;
         notNullMap[attrelid][attnum] = attNotNull;
         uniqueMap[attrelid][attnum] = uniqueConstraint;