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
class org.postgresql.util.PSQLException: ERROR: function extent(geometry) does not exist shouldn't PostGIS have some backword support for the extent function? thanks! Giri On Thu, Feb 26, 2009 at 2:40 AM, Paolo Rizzi <[email protected]> wrote: > > > * class org.geotools.data.DataSourceException: Could not count > > Request All Features > > * class org.postgresql.util.PSQLException: ERROR: function > > extent(geometry) does not exist > > Does function extent() still exists in newer version of PostGIS or was it > removed and replaced by ST_extent()??? > In the latter case, it's a Geotools problem, because it appears to be using > the old syntax. > > Bye > Paolo Rizzi > > > Hi, >> >> 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 >> >> * class org.geotools.data.DataSourceException: Could not count >> Request All Features >> * class org.postgresql.util.PSQLException: ERROR: function >> extent(geometry) does not exist >> >> org.geotools.data.DataSourceException: Could not count Request All >> Features >> at >> org.geotools.data.postgis.PostgisFeatureStore.bounds(PostgisFeatureStore.java:764) >> at >> org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:676) >> at >> org.geotools.data.postgis.PostgisFeatureStore.getBounds(PostgisFeatureStore.java:653) >> at >> org.geoserver.feature.FeatureSourceUtils.getBoundingBoxEnvelope(FeatureSourceUtils.java >> ......... >> Caused by: >> org.postgresql.util.PSQLException: ERROR: function extent(geometry) does >> not exist >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.j >> >> >> Not sure what is causing this error. >> >> thanks! >> >> Giri >> >> On Wed, Feb 25, 2009 at 5:14 AM, Mark Cave-Ayland < >> [email protected] <mailto:[email protected]>> >> wrote: >> >> ???(Sinboy Zhang) wrote: >> >> I got the same problem. >> >> OS:CentOS 5.2 >> PostgreSQL:8.2.6 >> Geos:3.0.0 >> proj:4.6.0 >> postgis:1.3.2 >> >> A few months ago,i installed them successully on Fedora 7,now a >> error boked when i installed on CentOS: >> >> ERROR: could not load library >> "/usr/local/postgis/lib/liblwgeom.so": libgeos_c.so.1: >> >> cannot open shared object file: No such file or directory >> >> But the file liblwgeom.so was existed surely in >> /usr/local/postgis/lib, i added /usr/local/postgis/lib to >> /etc/ld.conf.d/local.conf and execute ldconfig ,final restart >> postgresql ,but the error still exist. >> >> >> The error is telling you that PostgreSQL can't see libgeos_c.so.1 - >> you need to add the location of this file (normally /usr/local/lib) >> to /etc/ld.conf.d/local.conf and then run ldconfig so the OS can see >> it. On some older machines you may also have to restart the >> PostgreSQL server too. >> >> >> HTH, >> >> Mark. >> >> -- Mark Cave-Ayland - Senior Technical Architect >> PostgreSQL - PostGIS >> Sirius Corporation plc - control through freedom >> http://www.siriusit.co.uk >> t: +44 870 608 0063 >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> <mailto:[email protected]> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
