[Qgis-user] Multi User - QGIS

[Bernhard Ströbl]

Hi,
i use a sequence for this and a trigger, that ensures that the sequence 
is used, no matter what user input comes from QGIS;

trigger function:

CREATE FUNCTION shema.table_ensure_sequence()
     RETURNS trigger
AS $BODY$
DECLARE
     str_execute text;
BEGIN
     IF (TG_OP = 'INSERT') THEN
         NEW.id := nextval('schema.table_id_seq'); -- use sequence
     ELSIF (TG_OP = 'UPDATE') THEN
         NEW.id := OLD.id; -- do not allow user changes in id
     END IF;
     RETURN NEW;
END;
$BODY$;

Bernhard


Am 13.09.2021 um 08:27 schrieb Alexander Klemm - km3 teledienst GmbH:
> 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
> 
> 
> 
> __________ Information from ESET Mail Security, version of virus 
> signature database 23952 (20210913) __________
> 
> The message was checked by ESET Mail Security.
> http://www.eset.com <http://www.eset.com>
> 
> _______________________________________________
> 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
> 
> 
> 
> 
> __________ Information from ESET Mail Security, version of virus signature database 23952 (20210913) __________
> 
> The message was checked by ESET Mail Security.
> http://www.eset.com
> 




__________ Information from ESET Mail Security, version of virus signature database 23952 (20210913) __________

The message was checked by ESET Mail Security.
http://www.eset.com