[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