I am currently posting new table row using the cartodb sql api with the following commands:
update {table_name} set geom = ST_Transform(ST_SetSRID(ST_MakePoint(latitude, longitude),4326)
latitude and longitude are taken from numeric columns in my table. However the_geom is not updated, and instead an error is received.
I am aware I can use 'Georeference your dataset' within cartodb to update the the_geom...but I don't want to do this manually whenever I add new coordinates.
Is there a way to automatically update the_geom when I add new new longitude and latitude coordinates?