[postgis-users] Error using PostGIS and GEOM

[Kevin Neufeld]

Just a random thought here.  Did you accidentally install PostGIS in a schema other than public?   If so, is that schema 
on the search_path of the user you are using to connect within GeoServer?

Do you get the same answer when you do this from psql or PgAdminIII?
postgis=# select public.extent('POINT(0 0)');
     extent
--------------
  BOX(0 0,0 0)
(1 row)


Cheers,
Kevin

Giri wrote:
> Hi Mark,
> I am using the latest stable versions of Geoserver and PostGIS, the 
> installation looks good, no errors were reported.
> 
> Thanks!
> 
> Giri
> 
> On Fri, Feb 27, 2009 at 10:11 AM, Mark Cave-Ayland 
> <mark.cave-ayland at siriusit.co.uk 
> <mailto:mark.cave-ayland at siriusit.co.uk>> wrote:
> 
>     Giri wrote:
> 
>         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
> 
> 
> 
>     Hi Giri,
> 
>     There has been talk of removing the old non-ST prefix functions from
>     PostGIS, but so far this hasn't happened. Perhaps you need to check
>     your installation?
> 
> 
> 
>     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