Le portail francophone de la géomatique

DECLARE
   flag VARCHAR(32);
   
BEGIN


IF(TG_OP='INSERT') THEN
    -- INSERT INTO public.fon_parcelle_transaction_cavm (ogc_fid,the_geom) VALUES (NEW."ROWID",NEW."g");
    UPDATE cav_postgis.sb_data_309 SET superficie = area(NEW.g) WHERE rowid=NEW.rowid;
    UPDATE cav_postgis.sb_data_309 SET commune = public.cad_commune.commune 
    FROM public.cad_commune
    WHERE (ST_IsValid(NEW.g) 
    AND st_within(ST_PointOnSurface(NEW.g),public.cad_commune.the_geom)) 
    AND rowid = NEW.rowid; 
END IF;

IF(TG_OP='UPDATE') THEN 
    UPDATE cav_postgis.sb_data_309 SET superficie = area(NEW.g) WHERE rowid=NEW.rowid;
    UPDATE cav_postgis.sb_data_309 SET commune = public.cad_commune.commune 
    FROM public.cad_commune
    WHERE (ST_IsValid(NEW.g) 
    AND st_within(ST_PointOnSurface(NEW.g),public.cad_commune.the_geom)) 
    AND rowid = NEW.rowid; 

END IF; 

SET dynmap_pgconf.state_trigger_beetween_schemas='';

RETURN NEW;

END;