[postgis-users] Error using PostGIS and GEOM

[Giri]

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> 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
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090225/d9f656fa/attachment.html>