Advanced: 02 Site coordinate rebuild trigger.sql

File 02 Site coordinate rebuild trigger.sql, 273 bytes (added by 231139, 11 days ago)
Line 
1DROP TRIGGER IF EXISTS trg_network_sites_rebuild_coverage
2 ON public.network_sites;
3
4CREATE TRIGGER trg_network_sites_rebuild_coverage
5AFTER UPDATE OF latitude, longitude
6ON public.network_sites
7FOR EACH ROW
8EXECUTE FUNCTION public.rebuild_coverage_after_site_change();