<html>
<head>
</head>
<body style="margin-right: 4px; margin-top: 4px; margin-left: 4px; margin-bottom: 1px; line-height: normal; font-variant: normal">
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">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.</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">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. </font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">All makes sense once it's explained, but coming into to it cold . . . another story. :c)</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br> <br>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br>
>>> George Silva <georger.silva@gmail.com> wrote:<br> </p>
<table bgcolor="#f3f3f3" style="font-size: 1em; margin-right: 0; margin-top: 0; margin-left: 15px; margin-bottom: 0" border="0">
<tr>
<td>
<div style="border-left: solid 1px #050505; padding-left: 7px">
<p style="margin-bottom: 0; margin-top: 0">
Also you can confirm if PROJ4 is installed by: </p>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
SELECT * FROM POSTGIS_FULL_VERSION(); </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
If PROJ4 is installed, it should appear in that string. </p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
</div>
<div>
<p style="margin-bottom: 0; margin-top: 0">
George<br><br> </p>
<div class="gmail_quote">
<p style="margin-bottom: 0; margin-top: 0">
On Tue, Mar 6, 2012 at 3:48 PM, Mike Toews <span dir="ltr"><<a href="mailto:mwtoews@gmail.com">mwtoews@gmail.com</a>></span> wrote:<br> </p>
<blockquote class="gmail_quote" style="margin-right: 0; margin-top: 0; border-left: 1px #ccc solid; margin-left: 0; margin-bottom: 0; padding-left: 0">
<p style="margin-bottom: 0; margin-top: 0">
On 7 March 2012 06:10, Bob Basques <<a href="mailto:Bob.Basques@ci.stpaul.mn.us">Bob.Basques@ci.stpaul.mn.us</a>> wrote:<br>> ...<br> </p>
<div class="im">
<p style="margin-bottom: 0; margin-top: 0">
> ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric,<br>> part4::numeric),4326)), 200068) as geom_city<br> </p>
</div>
<p style="margin-bottom: 0; margin-top: 0">
> ...<br> </p>
<div class="im">
<p style="margin-bottom: 0; margin-top: 0">
> ERROR: function st_transform(geometry) does not exist<br>> LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...<br><br> </p>
</div>
<p style="margin-bottom: 0; margin-top: 0">
It looks like "4326)), 200068)" should be "4326), 200068))"<br><span class="HOEnZb"><font color="#888888"><br style="color: #888888">-Mike<br style="color: #888888"></font></span> </p>
<div class="HOEnZb">
<div class="h5">
<p style="margin-bottom: 0; margin-top: 0">
_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> </p>
</div>
</div>
</blockquote>
</div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
<br clear="all">
</p>
<div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
</div>
<p style="margin-bottom: 0; margin-top: 0">
--<br>George R. C. Silva<br><br>Desenvolvimento em GIS<br><a href="http://geoprocessamento.net" target="_blank">http://geoprocessamento.net</a><br><a href="http://blog.geoprocessamento.net" target="_blank">http://blog.geoprocessamento.net</a> </p>
<div style="font-size: 10px; padding-top: 0px; text-align: left; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; line-height: 130%; padding-right: 0px; padding-left: 0px; color: black">
<br>
</div>
<div style="font-size: 10px; padding-top: 0px; text-align: left; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; line-height: 130%; padding-right: 0px; padding-left: 0px; color: black">
<br>
</div>
<div style="font-size: 10px; padding-top: 0px; text-align: left; padding-bottom: 0px; margin-top: 0px; margin-left: 0px; line-height: 130%; padding-right: 0px; padding-left: 0px; color: black">
<br>
</div>
<p style="margin-bottom: 0; margin-top: 0">
<br>
</p>
</div>
</div>
</td>
</tr>
</table>
</body>
</html>