Bug report #6164: postgis layer: duplicate primary key - QGIS Application - QGIS Issue Tracking

Bug report #6164

postgis layer: duplicate primary key

Added by michele zanolli over 12 years ago. Updated almost 12 years ago.

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

Description

When I try to copy one feature from a postgis layer to another (or to the same layer), the value of the primary key (integer serial) is copied as it is, generating a duplicate key error:

Errors: ERROR: 1 feature(s) not added.

  Provider errors:
  PostGIS error while adding features: ERROR:  duplicate key value violates unique constraint "grafo_pk" 
DETAIL:  Key (ogc_fid)=(2630) already exists.

The same thing if I hide the pk field in the "Fields" property of the layer, to tell QGIS not to use it for copying.

Affected version: master and 1.8

Whith 1.7.4 it was working correctly!

Related issues

Associated revisions

Revision 2a002c55
Added by Jürgen Fischer almost 12 years ago

[API] make primary key field indexes available:
- add QgsVectorLayer::pendingPkAttributeList()
- add QgsVectorDataProvider::pkAttributeIndexes()
- skip primary key attribute when pasting features (fixes #6164)
- default to skip primary key attribute in when merging features/attributes
- reset primary key attributes to default value when splitting features (better fix for #6060)
- comment out unused QgsPasteTransformations