search

Cidree / rpostgis

rpostgis: R Interface to a 'PostGIS' Database
http://cidree.github.io/rpostgis/
77 stars 14 forks source link

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

Open CrimarHer opened 2 years ago

CrimarHer commented 2 years ago

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 commented 2 years ago

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!