--delete rulecreateorreplacerule"delete_label"asondeleteto schools_district_map do instead
deletefrom temp_schools_label
where oid = old.oid;--insert rulecreateorreplacerule"insert_label"asoninsertto schools_district_map do instead
insertinto district_map_labels (label_x, label_y)values(new.label_x, new.label_y);--update rulecreateorreplacerule"labels_update"asonUPDATETO schools_district_map do instead
update district_map_labels set
label_x = new.label_x,
label_y = new.label_y
where oid = new.oid;
postgis
--delete rulecreateorreplacerule"delete_test_line"asondeleteto test_line do instead
deletefrom test
where id = old.id;--insert rulecreateorreplacerule"insert_test_line"asoninsertto test_line do instead
insertinto test (id, jsb, geom)values(new.id, new.jsb, new.geom)RETURNING id, jsb, geom;--update rulecreateorreplacerule"update_test_line"asonUPDATETO test_line do instead
update test set
jsb = new.jsb,
geom = new.geom::geometrywhere id = new.id;