Postgre instead

--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;
 
 
 
drop rule rulename on tablename
 
 
 
 
 

Recommendations