--delete rule
create or replace rule "delete_label" as
on delete to schools_district_map do instead
delete from temp_schools_label
where oid = old.oid;
--insert rule
create or replace rule "insert_label" as
on insert to schools_district_map do instead
insert into district_map_labels (label_x, label_y)
values (new.label_x, new.label_y);
--update rule
create or replace rule "labels_update" as
on UPDATE TO 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 rule
create or replace rule "delete_test_line" as
on delete to test_line do instead
delete from test
where id = old.id;
--insert rule
create or replace rule "insert_test_line" as
on insert to test_line do instead
insert into test (id, jsb, geom)
values (new.id, new.jsb, new.geom)
RETURNING id, jsb, geom;
--update rule
create or replace rule "update_test_line" as
on UPDATE TO test_line do instead
update test set
jsb = new.jsb,
geom = new.geom::geometry
where id = new.id;
