[postgis-users] Why unrecognized field type?

[James David Smith]

Hi all,

Apologies for cross-posting this to the RPostrgeSQL and PostGIS mailing
lists, but I'm not sure where the problem lies.

I am using the RPostgreSQL package of R to connect to my installation of
PostgreSQL/PostGIS. I want to retrieve some coordinates from my database
and run the below command. Is this just that R doesn't know what to do with
Geometry's, or is it something I should be more concerned about? I ask, as
I'm having some wider issues with my workflow and this may be related.

Thanks

James

> dbGetQuery(con, "SELECT st_transform(st_setsrid(st_makepoint(soose::numeric, soosn::numeric),27700),4326) FROM stage WHERE ssid = '707187161010202'")


st_transform
1 0101000020E6100000F71184EF3961B3BF830420AF33C64940Warning message:In
postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver warning: (unrecognized PostgreSQL field type geometry
(id:480912) in column 0)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131203/88c29254/attachment.html>