[postgis-users] Error using PostGIS and GEOM

[Paolo Rizzi]

 >     * 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 
> <mark.cave-ayland at siriusit.co.uk 
> <mailto:mark.cave-ayland at siriusit.co.uk>> 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
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users