Bug report #21836

Copy/Paste fails in Postgis layer null value in column "gid" violates not-null constraint

Added by CATER Normandie over 3 years ago. Updated over 3 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:3.4.5 Regression?:Yes
Operating System:Windows 10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29651


When copy/past features from Shapefile layer to Postgis layer, an error occure "null value in column "gid" violates not-null constraint". Creating new feature work as expected.

Work well in QGIS 3.2 with same data.

Error occure with or without transaction group.

Don't know if something related with bug report #21788


#1 Updated by CATER Normandie over 3 years ago

"gid" column is here the primary key

QGIS 3.4.6 doesn't fix the issue

QGIS 3.6 fix it, can you bring the patch to the LTR ?

#2 Updated by Jürgen Fischer over 3 years ago

  • Description updated (diff)

Also available in: Atom PDF