[Qgis-user] Multi User - QGIS

[Andreas Neumann]

Hi Alexander,

If you use the PostgreSQL transaction mode, you can edit multiple 
related tables at once and get the IDs immediately (even before saving 
your data).

See Project -->  Properties --> Data Sources and enable at least the 
following two checkboxes potentially also the third one:

  	* Automatically create transaction groups where possible
  	* Evaluate default values on provider side

If you want to be on the safe side for future avoidance of ID clashes, 
you can also consider using UUID as your primary key column. That will 
allow you in the future to better merge independent data sources without 
having to worry about ID clashes.

Greetings,

Andreas

On 2021-09-13 09:45, Jorge Gustavo Rocha wrote:

> 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
> 
> _______________________________________________
> 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/4fe39208/attachment.html>