Applying COU

PL/pgSQL

-- delete updated and departed features
DELETE FROM topographicarea WHERE toid IN (SELECT distinct toid FROM update_topographicarea);
DELETE FROM topographicarea WHERE toid IN (SELECT distinct toid FROM departedfeature);
DELETE FROM topographicline WHERE toid IN (SELECT distinct toid FROM update_topographicline);
DELETE FROM topographicline WHERE toid IN (SELECT distinct toid FROM departedfeature);
DELETE FROM topographicpoint WHERE toid IN (SELECT distinct toid FROM update_topographicpoint);
DELETE FROM topographicpoint WHERE toid IN (SELECT distinct toid FROM departedfeature);
DELETE FROM boundaryline WHERE toid IN (SELECT distinct toid FROM update_boundaryline);
DELETE FROM boundaryline WHERE toid IN (SELECT distinct toid FROM departedfeature);
DELETE FROM cartographicsymbol WHERE toid IN (SELECT distinct toid FROM update_cartographicsymbol);
DELETE FROM cartographicsymbol WHERE toid IN (SELECT distinct toid FROM departedfeature);
DELETE FROM cartographictext WHERE toid IN (SELECT distinct toid FROM update_cartographictext);
DELETE FROM cartographictext WHERE toid IN (SELECT distinct toid FROM departedfeature);
 
-- insert updated features
INSERT INTO topographicarea SELECT * FROM update_topographicarea;
INSERT INTO topographicline SELECT * FROM update_topographicline;
INSERT INTO topographicpoint SELECT * FROM update_topographicpoint;
INSERT INTO boundaryline SELECT * FROM update_boundaryline;
INSERT INTO cartographicsymbol SELECT * FROM update_cartographicsymbol;
INSERT INTO cartographictext SELECT * FROM update_cartographictext;