[Mapbender-users] mb3: Digitizer / Trigger Problem

v.botz volker.emmel at lwk-rlp.de
Mon Jan 30 08:11:08 PST 2017


Hi,

i want to use mapbender 3 for an attribute editing tool.
> change attributes on geometries via a gui...
*in principel it works fine with the digitizer function. *

*But if i use a trigger / function on the table i am editing, i got errors
(without trigger everything is fine).*
If i start the trigger with sql it works fine!

*Error in dev log:    emergency: Call to a member function getId() on
boolean...*

My Trigger / Function:
/
CREATE TRIGGER a_delete_el_alle
        AFTER UPDATE
        ON weinbau_edit.el_alle_alkis_liste
        FOR EACH ROW
        EXECUTE PROCEDURE a_delete_el_alle();

CREATE OR REPLACE FUNCTION a_delete_el_alle() RETURNS TRIGGER AS $$
        BEGIN
         INSERT INTO weinbau_edit.el_alle_alkis (code, the_geom, wlg_nr,
erfasser, stand)
	 (select  code, NEW.the_geom, NEW.wlg_nr, 'engisch_gis', now() from
weinbau_edit.el_alle_alkis_liste where code = NEW.code);
	 delete from weinbau_edit.el_alle_alkis_liste where code = NEW.code;
     RETURN NULL;
         END;
 $$ LANGUAGE plpgsql;/

Has anyone an idea what the problem is ???

Thanx Volk.



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mb3-Digitizer-Trigger-Problem-tp5305326.html
Sent from the mapbender-users mailing list archive at Nabble.com.


More information about the Mapbender_users mailing list