Fix postgres server imposed NOT NULL constraint

m-kuhn · m-kuhn · commit 132d7f2a1ec3 · 2017-08-07T19:46:13.000+02:00
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -1828,7 +1828,7 @@ bool QgsPostgresProvider::skipConstraintCheck( int fieldIndex, QgsFieldConstrain
   {
     // stricter check - if we are evaluating default values only on commit then we can only bypass the check
     // if the attribute values matches the original default clause
-    return mDefaultValues.contains( fieldIndex ) && mDefaultValues.value( fieldIndex ) == value.toString();
+    return mDefaultValues.contains( fieldIndex ) && mDefaultValues.value( fieldIndex ) == value.toString() && !value.isNull();
   }
 }
 

Original file line number	Diff line number	Diff line change
`@@ -1828,7 +1828,7 @@ bool QgsPostgresProvider::skipConstraintCheck( int fieldIndex, QgsFieldConstrain`
`1828`	`1828`	`{`
`1829`	`1829`	`// stricter check - if we are evaluating default values only on commit then we can only bypass the check`
`1830`	`1830`	`// if the attribute values matches the original default clause`
`1831`		`- return mDefaultValues.contains( fieldIndex ) && mDefaultValues.value( fieldIndex ) == value.toString();`
	`1831`	`+ return mDefaultValues.contains( fieldIndex ) && mDefaultValues.value( fieldIndex ) == value.toString() && !value.isNull();`
`1832`	`1832`	`}`
`1833`	`1833`	`}`
`1834`	`1834`