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 <[email protected]>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 <
>> [email protected] <mailto:[email protected]>>
>> 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
>> [email protected]
>> <mailto:[email protected]>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> postgis-users mailing list
>> [email protected]
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
