I'm glad it worked! On Wed, Mar 7, 2012 at 11:29 AM, Bob Basques <bob.basq...@ci.stpaul.mn.us>wrote:
> 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 > > -- 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
