https://issues.qgis.org/https://issues.qgis.org/favicon.ico2019-04-10T15:24:55ZQGIS Issue TrackingQGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1038642019-04-10T15:24:55ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>Can you please detail the precise steps to replicate (also the sql used to create the table and the PK with the a attributes), thanks!</p> QGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1038782019-04-10T15:55:35ZSebastian Brockssebastian@brocks.cc
<ul></ul><p>Here's the sql for the table:</p>
<p>CREATE TABLE public.nullpunkt(<br /> nummer integer NOT NULL,<br /> bezeichnung varchar(1) NOT NULL,<br /> geometrie geometry(POINT, 4326),<br /> CONSTRAINT nullpunkt_pk PRIMARY KEY (nummer,bezeichnung)</p>
<p>);</p>
<p>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.<br />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.</p> QGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1038932019-04-10T16:51:10ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><blockquote>
<p>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.</p>
</blockquote>
<p>do they have the same name as the postgis table?</p> QGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1039152019-04-11T07:12:15ZSebastian Brockssebastian@brocks.cc
<ul></ul><p>Yes they do</p> QGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1039162019-04-11T07:15:25ZSebastian Brockssebastian@brocks.cc
<ul><li><strong>File</strong> <a href="/attachments/download/14778/paste_error.png">paste_error.png</a> added</li></ul><p>See the attached picture: "Pasted" contains the features I want to copy into "nullpunkt". What you see in nullpunkt is the result of pasting the features that are selected in "Pasted" into "nullpunkt"</p> QGIS Application - Bug report #21809: when pasting features to postgresql layer, attributes that are a primary key do not have the values pastedhttps://issues.qgis.org/issues/21809?journal_id=1039452019-04-11T21:15:09ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Sebastian Brocks wrote:</p>
<blockquote>
<p>See the attached picture: "Pasted" contains the features I want to copy into "nullpunkt". What you see in nullpunkt is the result of pasting the features that are selected in "Pasted" into "nullpunkt"</p>
</blockquote>
<p>I cannot replicate here.</p>