Thanks for the response, mmm I am using Geoserver (version1.7.2) , and when I try to create the featureType "polygon", it is complaining about <br><br>class org.postgresql.util.PSQLException: ERROR: function extent(geometry) does not exist<br>
<br>shouldn't PostGIS have some backword support for the extent function?<br><br>thanks!<br><br>Giri<br><br><br><div class="gmail_quote">On Thu, Feb 26, 2009 at 2:40 AM, Paolo Rizzi <span dir="ltr"><<a href="mailto:gis@oicom.com">gis@oicom.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
> * class org.geotools.data.DataSourceException: Could not count<div class="Ih2E3d"><br>
> Request All Features<br>
> * class org.postgresql.util.PSQLException: ERROR: function<br>
> extent(geometry) does not exist<br>
<br></div>
Does function extent() still exists in newer version of PostGIS or was it removed and replaced by ST_extent()???<br>
In the latter case, it's a Geotools problem, because it appears to be using the old syntax.<br>
<br>
Bye<br>
Paolo Rizzi<br>
<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">
Hi,<br>
<br>
Thanks for your responses, I have tried all your suggestions, and also ended up re-installing the PostGIS. Using the Geoserver, I am trying to add a new Feature type with the polygon It now complains about the following error<br>
<br>
* class org.geotools.data.DataSourceException: Could not count<br>
Request All Features<br>
* class org.postgresql.util.PSQLException: ERROR: function<br>
extent(geometry) does not exist<br>
<br>
org.geotools.data.DataSourceException: Could not count Request All Features<br>
at org.geotools.data.postgis.PostgisFeatureStore.bounds(PostgisFeatureStore.java:764)<br>
at org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:676)<br>
at org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:653)<br>
at org.geoserver.feature.FeatureSourceUtils.getBoundingBoxEnvelope(FeatureSourceUtils.java<br>
.........<br>
Caused by:<br>
org.postgresql.util.PSQLException: ERROR: function extent(geometry) does not exist<br>
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.j<br>
<br>
<br>
Not sure what is causing this error.<br>
<br>
thanks!<br>
<br>
Giri<br>
<br></div><div><div></div><div class="Wj3C7c">
On Wed, Feb 25, 2009 at 5:14 AM, Mark Cave-Ayland <<a href="mailto:mark.cave-ayland@siriusit.co.uk" target="_blank">mark.cave-ayland@siriusit.co.uk</a> <mailto:<a href="mailto:mark.cave-ayland@siriusit.co.uk" target="_blank">mark.cave-ayland@siriusit.co.uk</a>>> wrote:<br>
<br>
???(Sinboy Zhang) wrote:<br>
<br>
I got the same problem.<br>
<br>
OS:CentOS 5.2<br>
PostgreSQL:8.2.6<br>
Geos:3.0.0<br>
proj:4.6.0<br>
postgis:1.3.2<br>
<br>
A few months ago,i installed them successully on Fedora 7,now a<br>
error boked when i installed on CentOS:<br>
<br>
ERROR: could not load library<br>
"/usr/local/postgis/lib/liblwgeom.so": libgeos_c.so.1:<br>
<br>
cannot open shared object file: No such file or directory<br>
<br>
But the file liblwgeom.so was existed surely in<br>
/usr/local/postgis/lib, i added /usr/local/postgis/lib to<br>
/etc/ld.conf.d/local.conf and execute ldconfig ,final restart<br>
postgresql ,but the error still exist.<br>
<br>
<br>
The error is telling you that PostgreSQL can't see libgeos_c.so.1 -<br>
you need to add the location of this file (normally /usr/local/lib)<br>
to /etc/ld.conf.d/local.conf and then run ldconfig so the OS can see<br>
it. On some older machines you may also have to restart the<br>
PostgreSQL server too.<br>
<br>
<br>
HTH,<br>
<br>
Mark.<br>
<br>
-- Mark Cave-Ayland - Senior Technical Architect<br>
PostgreSQL - PostGIS<br>
Sirius Corporation plc - control through freedom<br>
<a href="http://www.siriusit.co.uk" target="_blank">http://www.siriusit.co.uk</a><br>
t: +44 870 608 0063<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br></div></div>
<mailto:<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a>><div class="Ih2E3d"><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<br></div>
------------------------------------------------------------------------<div class="Ih2E3d"><br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">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>
</div></blockquote><div><div></div><div class="Wj3C7c">
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">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>
</div></div></blockquote></div><br>