[postgis-users] Error using PostGIS and GEOM

[Giri]

HI Kevin,

Sorry for this delayed response, when I tried the query, I am getting the
following error:

----------------------------
processdb=# select public.extent('POINT(0 0)');
ERROR:  function public.extent("unknown") does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.
----------------------------

any idea?

Thanks!

Giri

On Mon, Mar 2, 2009 at 12:43 PM, Kevin Neufeld <kneufeld at refractions.net>wrote:

> 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
>>
> _______________________________________________
> 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/20090403/c6e78bc8/attachment.html>