All, I'm no expert in postgis by any means, but I did try that, and I only got a return with the POSTGIS version. I know that all those components are there (Since I eventually got it working, but that way the POSTGIS reports things like permission error and such is very subtle IMO, and some things need to be considered in different ways.
I ended up switching LAT/LON for LON/LAT in my query, which was giving me a permission denied error. Once I switched the numbers around, it all worked fine, no permission changes or anything. I've since been informed, that my erroneous query was trying to add a spatial project that didn't exist, hence the permissions error. All makes sense once it's explained, but coming into to it cold . . . another story. :c) bobb >>> George Silva <georger.si...@gmail.com> wrote: Also you can confirm if PROJ4 is installed by: SELECT * FROM POSTGIS_FULL_VERSION(); If PROJ4 is installed, it should appear in that string. George On Tue, Mar 6, 2012 at 3:48 PM, Mike Toews <mwto...@gmail.com> wrote: On 7 March 2012 06:10, Bob Basques <bob.basq...@ci.stpaul.mn.us> wrote: > ... > ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, > part4::numeric),4326)), 200068) as geom_city > ... > ERROR: function st_transform(geometry) does not exist > LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa... It looks like "4326)), 200068)" should be "4326), 200068))" -Mike _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- George R. C. Silva Desenvolvimento em GIS http://geoprocessamento.net http://blog.geoprocessamento.net
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
