Bug report #21809
when pasting features to postgresql layer, attributes that are a primary key do not have the values pasted
|Affected QGIS version:||3.6.1||Regression?:||No|
|Operating System:||windows 7||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||29624|
I'm trying to paste a few features into a postgresql layer that has two attributes that together form the table's primary key. The values of the attributes are not pasted correctly, although both name and order and type match.
#2 Updated by Sebastian Brocks over 2 years ago
Here's the sql for the table:
CREATE TABLE public.nullpunkt(
nummer integer NOT NULL,
bezeichnung varchar(1) NOT NULL,
geometrie geometry(POINT, 4326),
CONSTRAINT nullpunkt_pk PRIMARY KEY (nummer,bezeichnung)
I have a temporary scratch layer with a few point features with two attributes, one integer of length 10, and one string of length 1.
When I try to paste point featuers into the nullpunkt layer, the attribute values are not pasted correctly. for the first two features that are pasted, the number is correct, the other features don't have the correct number. the string is incorrect for all.