Populate illegal field names for postgres connection

qgis · Nov 30, 2022 · 82462b5 · 82462b5
1 parent eab3edb
commit 82462b5
Showing 1 changed file with 12 additions and 0 deletions.
diff --git a/src/providers/postgres/qgspostgresproviderconnection.cpp b/src/providers/postgres/qgspostgresproviderconnection.cpp
@@ -132,6 +132,18 @@ void QgsPostgresProviderConnection::setDefaultCapabilities()
     Qgis::SqlLayerDefinitionCapability::GeometryColumn,
     Qgis::SqlLayerDefinitionCapability::UnstableFeatureIds,
   };
+
+  // see https://www.postgresql.org/docs/current/ddl-system-columns.html
+  mIllegalFieldNames =
+  {
+    QStringLiteral( "tableoid" ),
+    QStringLiteral( "xmin" ),
+    QStringLiteral( "cmin" ),
+    QStringLiteral( "xmax" ),
+    QStringLiteral( "cmax" ),
+    QStringLiteral( "ctid" ),
+
+  };
 }
 
 void QgsPostgresProviderConnection::dropTablePrivate( const QString &schema, const QString &name ) const