pgGetGeom() other.cols = TRUE by default restarts session

[CrimarHer]

trafficstars

Hi,

R version 4.1.2 (2021-11-01) -- "Bird Hippie" rpostgis_1.4.3 RPostgreSQL_0.7-3 DBI_1.1.2

pgGetGeom has other.cols = T by default and when you use the fucntion without the argument other.cols it restarts my R session instead of throwing an error.

` #this works pgGetGeom(con, query=paste0("QUERY HERE "), other.cols=c("col1","col2", "col3")) pgGetGeom(con, query=paste0("QUERY HERE "), other.cols=F)

#this doesn't work and terminates R session pgGetGeom(con, query=paste0("QUERY HERE ")) ` This didn't happen with previous versions

Thanks!

[basille]

Hi @CrimarHer! Thanks for reporting. Unfortunately, rpostgis is not actively developed anymore, and I worry that we won't have the resources to check into this bug, which is a pity. I'll leave the issue open though, and add a note on my to-do list, but I'm not very optimistic about it.

This said, now that the sf package has achieved maturity, I can only advise you to have a look there. You should be able to import pretty much anything from a PostGIS database into R, in a very simple way with sf::st_read. Check for instance this blog post for more details on how to get things working. Hope this helps!