[Mapbender-users] Digitizer using VIEW not TABLE

[Astrid Emde]

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 at 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 at 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
-------------------------------