[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