[Qgis-user] Multi User - QGIS

[Jorge Gustavo Rocha]

Hi Alexander,

You should not set an expression manually. If the id column is comes
from a PostgreSQL identity/sequence based column, QGIS is get the exact
id when the write operation is executed. It works fine with any number
of users.

Set you column with (on the PostgreSQL side):

id INT GENERATED ALWAYS AS IDENTITY

I hope it helps.

Jorge Gustavo

On 13/09/21 07:27, Alexander Klemm - km3 teledienst GmbH wrote:
>
> Hello,
>
> we want to use QGIS to document our cable Infrastructure (We are an
> ISP). Now the Problem is, that 3 or 4 persons have to work with QGIS.
> Now my Idea was to provide a Postgresql Server with postgis installed.
> Thats working fine. The Project and the Layers are stored into the
> Postgresql Server and all Persons could work with it. Now my Problem
> is, that the Contents of the Layers must have an unique ID. The ID is
> set by the default value at the attribute form with/"maximum($id)+1"/.
> If two persons are working on the QGIS System, the Problem is, that
> there are duplicated IDs, because the IDs will not be stored
> immediately. Is there a solution for this problem?
>
> thank you for helping
> best regards
>
> Alexander Klemm
>
> Mit freundlichen Grüßen
> Alexander Klemm
>
> km3 teledienst GmbH - August-Bebel-Str. 86 - 08344 Grünhain-Beierfeld
> Tel. +49 (0)3774 13931-0 - Fax +49 (0)3774 13931-02
> buero at km3.de - https://www.km3.de
> Geschäftsführer: Heiko Lötzsch und Mike Bielagk
> Registergericht: Amtsgericht Chemnitz - Handelsregister: B Nr. 18881
> Umsatzsteuer-ID: DE 216 086 551 - Steuer-Nr.: 218 / 112 / 02921
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210913/0d989e88/attachment.html>