[Qgis-user] split features tool on postgres layer causes pkey violation

Janneke van Dijk janneke.qgis at gmail.com
Wed Nov 25 11:14:29 PST 2015


Dear all,

When using the split features tool in 2.10 and 2.12 on a postgres layer 
(both on windows 7 and windows xp) I receive the following error after 
trying to save the edits:

"
Could not commit changes to layer a_streets


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

Provider errors:

PostGIS error while adding features: ERROR: duplicate key value violates 
unique constraint "streets_pkey"

DETAIL: Key (streetsid)=(5) already exists.

"
The a_streets table has a serial primary key.

It seems similar to the bug described here: https://hub.qgis.org/issues/5475
in 1.9 that was apparently fixed 3 years ago.

Is this indeed a bug? Or can the tool not be used on postgres layers?

Thanks for any insights,

Janneke



More information about the Qgis-user mailing list