Bug report #7388

Feature merging fails for Postgis tables if pkey is not set

Added by Andreas Neumann over 7 years ago. Updated over 7 years ago.

Status:Closed
Priority:Severe/Regression
Assignee:Jürgen Fischer
Category:Digitising
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:16359

Description

When digitising new lines in a Postgis table and merging them with the merge features tool one gets an error messages saving these merged lines:

"Error: Invalid input syntax for integer: "

My guess is that QGIS tries to write the features with negative pkey values while Postgis only accepts positive pkey values. QGIS should ignore the pkey values, if the value is negative and leave it up to the database to create new values. If the pkey value is positive, QGIS should use the existing pkey value from the user.

History

#1 Updated by Andreas Neumann over 7 years ago

  • Assignee set to Jürgen Fischer

#2 Updated by Andreas Neumann over 7 years ago

  • Resolution set to worksforme
  • Status changed from Open to Closed

Seems to work now fine in current master.

Also available in: Atom PDF