[prev in list] [next in list] [prev in thread] [next in thread]
List: mapbender-users
Subject: Re: [Mapbender-users] Digitizer using VIEW not TABLE
From: Astrid Emde <astrid.emde () wheregroup ! com>
Date: 2019-01-31 15:46:00
Message-ID: 60dd789f6552483de9245b3c7a3ce7b2 () wheregroup ! com
[Download RAW message or body]
Hello Zsolt,
great that you found a solution and thanks for sharing.
Astrid
Am 2019-01-31 15:04, schrieb Gal Zsolt:
> Hello,
>
> I find the solution. I have a mistake in the trigger function.
>
> In the
>
> ........
> ELSIF (TG_OP='INSERT') THEN
>
> ......................
>
> RETURN NEW;
>
> I return NEW but NEW.gid vas null. I change the code to
>
> ELSIF (TG_OP='INSERT') THEN
>
> NEW.GID=NEXTVAL(PG_GET_SERIAL_SEQUENCE('TGS_ARBORI_UTF8','GID'));
>
> INSERT INTO tgs_arbori_utf8
>
> (gid, objectid, id_n_specia, inaltime, coronament, diametru,
> id_n_viabilitate, ocrotit, observatii, anplantare,
>
> geom)
>
> VALUES
>
> (NEW.gid, NEW.objectid, NEW.id_n_specia, NEW.inaltime,
> NEW.coronament, NEW.diametru, NEW.id_n_viabilitate,
>
> NEW.ocrotit, NEW.observatii, NEW.anplantare, NEW.geom);
>
> return NEW;
>
> END IF;
>
> I promiss next time I will wait before I ask/write for help. :-)
>
> Zsolt.
>
> P.S. Moving feature stil not saved, but I can live with this problem.
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapbender_users
--
Mit freundlichen Grüßen
Astrid Emde
GIS-Consultant
****************************************************************************
FOSS Academy Kompaktkurs "Winterschule 2019"
Grundwissen zum Aufbau von Geodateninfrastrukturen mit
Open-Source-Software
https://foss-academy.com/kompaktkurse
****************************************************************************
Astrid Emde
WhereGroup GmbH & Co.KG
Eifelstraße 7
53119 Bonn
Germany
Fon: +49(0)228 90 90 38 - 22
Fax: +49(0)228 90 90 38 - 11
astrid.emde@wheregroup.com
www.wheregroup.com
Folgen Sie der WhereGroup auf twitter:
http://twitter.com/WhereGroup_com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
_______________________________________________
Mapbender_users mailing list
Mapbender_users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapbender_users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic