G'day all, I am having a problem with using the rgdal function readOGR, but the error message actually relates to using ogrInfo.
> backgroundmap <- readOGR("PG:dbname=gms user=benmadin password=xdi4frt", > "seaplus_countries") Error in ogrInfo(dsn = dsn, layer = layer, input_field_name_encoding = input_field_name_encoding) : GDAL Error 1: No field definitions found for 'seaplus_countries', is it a table? > ogrInfo("PG:dbname=gms user=benmadin password= xdi4frt", "seaplus_countries", > input_field_name_encoding=UTF-8) Error in ogrInfo("PG:dbname=gms user=benmadin password= xdi4frt", "seaplus_countries", : GDAL Error 1: No field definitions found for 'seaplus_countries', is it a table? Yet when I use ogrInfo from the command line it shows me the information : warrambat:~ benmadin$ ogrinfo "PG:dbname=gms user=benmadin password= xdi4frt" INFO: Open of `PG:dbname=gms user=benmadin password= xdi4frt' using driver `PostgreSQL' successful. rows deleted 20: public.country (Multi Polygon) 21: public.seaplus_countries (Multi Polygon) 22: public.worldboundaries (Multi Polygon) and I can load the layer and display it in QGIS or uDig. The problem occurs both in the GUI and the command line versions of R. > sessionInfo() R version 2.11.1 Patched (2010-09-30 r53084) Platform: x86_64-apple-darwin9.8.0/x86_64 (64-bit) locale: [1] en_AU.UTF-8/en_AU.UTF-8/C/C/en_AU.UTF-8/en_AU.UTF-8 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] rgdal_0.6-28 sp_0.9-72 loaded via a namespace (and not attached): [1] grid_2.11.1 lattice_0.19-13 I have tried this with a number of postgis tables in different databases, and it is not working. I am trying to re-run code that has previously worked fine, but I am on a new computer and using R2.11 and a more recent version of rgdal. My first question is - what does the error message mean? My second question - why is it occurring in R, but not (apparently) a problem outside of R? My third question - am I on the right list? cheers Ben _______________________________________________ R-sig-Geo mailing list R-sig-Geo@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo