[postgis-users] Error using PostGIS and GEOM

[Giri]

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 <gis at oicom.com> 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 <
>> 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
>>
>
> _______________________________________________
> 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/20090226/2e3eb39e/attachment.html>