A before insert/update trigger on one of my CartoDB tables is not being raised. Same trigger is working in a local installation of PostGIS.
This is my source table. And here, the trigger's code:
CREATE OR REPLACE FUNCTION update_geom_column()RETURNS trigger AS$BODY$DECLARE coords_array varchar[] := ARRAY[2];BEGIN if new.map_url is null then raise exception 'map_url cannot be null'; end if; -- Get coords using regexp_matches select regexp_matches(NEW.map_url, 'center=(-?[\d]*\.[\d]*),(-?[\d]*\.[\d]*)&') into coords_array; NEW.the_geom = CDB_LatLng(coords_array[1]::numeric, coords_array[2]::numeric); return NEW;END;$BODY$LANGUAGE plpgsql VOLATILECOST 100;drop trigger if exists update_geom_column_trigger on foursquare_checkins;CREATE TRIGGER update_geom_column_triggerBEFORE INSERT OR UPDATEON foursquare_checkinsFOR EACH ROWEXECUTE PROCEDURE update_geom_column();Every time there's a new insertion in my CartoDB table, all geometry fields of all rows are set to null. But the same trigger is working in my local PostGIS.
May it be something related with CartoDB itself?
أكثر...
This is my source table. And here, the trigger's code:
CREATE OR REPLACE FUNCTION update_geom_column()RETURNS trigger AS$BODY$DECLARE coords_array varchar[] := ARRAY[2];BEGIN if new.map_url is null then raise exception 'map_url cannot be null'; end if; -- Get coords using regexp_matches select regexp_matches(NEW.map_url, 'center=(-?[\d]*\.[\d]*),(-?[\d]*\.[\d]*)&') into coords_array; NEW.the_geom = CDB_LatLng(coords_array[1]::numeric, coords_array[2]::numeric); return NEW;END;$BODY$LANGUAGE plpgsql VOLATILECOST 100;drop trigger if exists update_geom_column_trigger on foursquare_checkins;CREATE TRIGGER update_geom_column_triggerBEFORE INSERT OR UPDATEON foursquare_checkinsFOR EACH ROWEXECUTE PROCEDURE update_geom_column();Every time there's a new insertion in my CartoDB table, all geometry fields of all rows are set to null. But the same trigger is working in my local PostGIS.
May it be something related with CartoDB itself?
أكثر...