Hi,
I cannot confirm this behaviour neither with 2.8 on Win7 nor with 2.10
on Linux. When asking the new features with the "i" tool after
splitting, one keeps its pk value the other displays
nextval("my_sequence"). Maybe the problem is that features have received
pk values by other means then nextval("sequence"), thus the sequence's
current start value is lower than the maximum pk value. To avoid such
confusion I create a BEFORE INSERT or UPDATE trigger for my tables. This
is the trigger function:
CREATE OR REPLACE FUNCTION my_schema.my_table_ensure_sequence()
RETURNS trigger AS
$BODY$
BEGIN
IF (TG_OP = 'INSERT') THEN
NEW.id:= nextval('my_id_seq');
ELSIF (TG_OP = 'UPDATE') THEN
NEW.id := OLD.id;
END IF;
RETURN NEW;
END; $BODY$
LANGUAGE plpgsql VOLATILE
Users cannot manipulate the value of the id field anymore neither when
INSERTing nor when UPDATEing.
Bernhard
Am 25.11.2015 um 20:14 schrieb Janneke van Dijk:
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
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
__________ Information from ESET Mail Security, version of virus signature
database 12628 (20151126) __________
The message was checked by ESET Mail Security.
http://www.eset.com
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
