[postgis-users] Spatial column from text via a VIEW, Possible?

[Bob Basques]

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.silva at 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 <mwtoews at gmail.com> wrote:



On 7 March 2012 06:10, Bob Basques <Bob.Basques at 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 at 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 




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120307/a9fbb401/attachment.html>