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

Error editing 'editable' view in QGIS

Taking some code from this post, I've been trying to create an 'editable' view in PostGIS. I'd like to store label placement properties in a separate table, build a view of the data I want to use for my map, and use QGIS to move the labels.

https://gis.stackexchange.com/questions/201181/error-editing-editable-view-in-qgis

DROP RULE

This documentation is for an unsupported version of PostgreSQL. You may want to view the same page for the current version, or one of the other supported versions listed above instead. DROP RULE -- remove a rewrite rule DROP RULE [ IF EXISTS ]name ON table_name [ CASCADE | RESTRICT ] DROP RULE drops a rewrite rule.

https://www.postgresql.org/docs/9.2/sql-droprule.html