search

NTNU-VM / natronR

0 stars 0 forks source link

f_upsert_location crashes #12

Open anders-kolstad opened 5 years ago

anders-kolstad commented 5 years ago

The example_run_trhough_r crashes on the last line:

f_upsert_location(conn,location_data) NOTICE: table "temp_location_import" does not exist, skipping Error in postgresqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not Retrieve the result : ERROR: syntax error at or near ";" LINE 28: ; ^ )

andersfi commented 5 years ago

upsert_locations have troubles with geom columns. Try using the postgis capabilites of the SF package instead (https://r-spatial.github.io/sf/reference/st_write.html). In general, most of the spatial stuff in natronR could be facilitated by using SF package in order to simplify communication with postgis layers of the database.