Re: [QGIS-Developer] Merge tool always creating a new feature id instead of preserving the existing one
I would consider that a bug then, but I can't remember if I ever used merge tool on PostGIS tables directly. I believe NaturalGIS has some processing tools that work in PostGIS backend, but can't remember if merge is available. Alexandre A terça, 1/03/2022, 09:24, Andreas Neumann escreveu: > Hi Alex, > > Thank you for your reply. > > In my case, the data resides in Postgis, not in Geopackage. > > But if I understand you correctly, then Geopackage imposes it's limit on > QGIS in general, aka other providers as well - right? > > Thanks, > Andreas > > On 2022-03-01 10:16, Alexandre Neto wrote: > > I believe that comes from the geopackage fid limitations. For that reason, > I never use the fid field as an actual id. That's my workaround. > > Alexandre Neto > > A terça, 1/03/2022, 08:44, Andreas Neumann escreveu: > > Hi, > > We have a problem with the merge tool. > > We have a relatively complex data model with lots of relations. We want to > use the merge tool with this data. > > The merge tool allows to carefully choose which attributes should end up > in the merged feature. This works fine, except for the feature ID. > > QGIS stubbornly insists on having to create a new feature ID after the > merge - and is not reusing the feature ID of the original feature we > selected as the "master" feature in the merge tool. > > This is a huge problem - because after the merge we loose all relations, > because the feature ID has changed. > > Do you know any work around? Would we be able to fix this behaviour in a > future QGIS release? > > Thanks for the discussion, > > Andreas > ___ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > > > ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] Merge tool always creating a new feature id instead of preserving the existing one
Hi Alex, Thank you for your reply. In my case, the data resides in Postgis, not in Geopackage. But if I understand you correctly, then Geopackage imposes it's limit on QGIS in general, aka other providers as well - right? Thanks, Andreas On 2022-03-01 10:16, Alexandre Neto wrote: I believe that comes from the geopackage fid limitations. For that reason, I never use the fid field as an actual id. That's my workaround. Alexandre Neto A terça, 1/03/2022, 08:44, Andreas Neumann escreveu: Hi, We have a problem with the merge tool. We have a relatively complex data model with lots of relations. We want to use the merge tool with this data. The merge tool allows to carefully choose which attributes should end up in the merged feature. This works fine, except for the feature ID. QGIS stubbornly insists on having to create a new feature ID after the merge - and is not reusing the feature ID of the original feature we selected as the "master" feature in the merge tool. This is a huge problem - because after the merge we loose all relations, because the feature ID has changed. Do you know any work around? Would we be able to fix this behaviour in a future QGIS release? Thanks for the discussion, Andreas ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] Merge tool always creating a new feature id instead of preserving the existing one
I believe that comes from the geopackage fid limitations. For that reason, I never use the fid field as an actual id. That's my workaround. Alexandre Neto A terça, 1/03/2022, 08:44, Andreas Neumann escreveu: > Hi, > > We have a problem with the merge tool. > > We have a relatively complex data model with lots of relations. We want to > use the merge tool with this data. > > The merge tool allows to carefully choose which attributes should end up > in the merged feature. This works fine, except for the feature ID. > > QGIS stubbornly insists on having to create a new feature ID after the > merge - and is not reusing the feature ID of the original feature we > selected as the "master" feature in the merge tool. > > This is a huge problem - because after the merge we loose all relations, > because the feature ID has changed. > > Do you know any work around? Would we be able to fix this behaviour in a > future QGIS release? > > Thanks for the discussion, > > Andreas > ___ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer > ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
[QGIS-Developer] Merge tool always creating a new feature id instead of preserving the existing one
Hi, We have a problem with the merge tool. We have a relatively complex data model with lots of relations. We want to use the merge tool with this data. The merge tool allows to carefully choose which attributes should end up in the merged feature. This works fine, except for the feature ID. QGIS stubbornly insists on having to create a new feature ID after the merge - and is not reusing the feature ID of the original feature we selected as the "master" feature in the merge tool. This is a huge problem - because after the merge we loose all relations, because the feature ID has changed. Do you know any work around? Would we be able to fix this behaviour in a future QGIS release? Thanks for the discussion, Andreas___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer