> * 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
