Thanks muchly, Justin.
Did the trick! I had tried setting the search_path without improving my success - guess I had incomplete syntax.
Thanks again for the quick support.
Mick Wilson
Division of Early Warning and Assessment (DEWA)
United Nations Environment Programme
PO Box 30552 - Nairobi 00100, Kenya
Tel: +254 20 7623436
Skype: mickwilson20
Fax: +254 20 7624315
Email: mick.wilson@anonymised.com
Lat: 1°14’3.72"S Lon: 36°49’5.93"E
Web www.unep.net, www.unep.org
Justin Deoliveira <jdeolive@anonymised.com…>
Justin Deoliveira jdeolive@anonymised.com
04/06/2009 01:52 AM
To
![]()
Mick Wilson Mick.Wilson@anonymised.com
![]()
cc
![]()
geoserver-users@lists.sourceforge.net
![]()
Subject
![]()
Re: [Geoserver-users] Postgis functions under postgres schemas
![]()
![]()
I am told by one of our postgis experts that you can probably fix this
by changing the default search path of the user geoserver is logging in as:
alter user myuser set search_path to mypostgisschema,public
That might do the trick for you.
-Justin
Justin Deoliveira wrote:
> Hi Mick,
>
> My guess is that if postgis is installed locally in your schema (i have
> never seen this before, usually it is installed globally) then geoserver
> will not find your functions, because it never prefixes functions with
> the schema, only your data.
>
> How did you go about installing postgis to a specific schema? Is this
> required in your case?
>
> -Justin
>
> Mick Wilson wrote:
>> Apologies in advance if this query is better suited to the postgres and
>> postgis lists but it does strike me as being more in the province of
>> geoserver.
>>
>> I have a postgres database with a schema (called 'cger') into which I
>> have loaded the postgis library and have loaded many tables into a
>> database called 'Global'. I have successfully established a datastore
>> called CGERhydro that points to database Global in schema cger.
>>
>> My problem is that when in geoserver I attempt to establish a new
>> feature type I get the following error: "An SQL exception occurred:
>> ERROR: function force_2d(cger.geometry) does not exist ".
>>
>> force_2d does in fact list within the functions available in the cger
>> schema. Also, if I move the data table under the 'public' schema then
>> geoserver is able to create the feature type without problem. My
>> googling shows that others have confronted and resolved these types of
>> issues but nowhere have I found -how- they are resolved.
>>
>> Thanks in advance for any advice.
>>
>> Mick Wilson
>> Division of Early Warning and Assessment (DEWA)
>> United Nations Environment Programme
>> PO Box 30552 - Nairobi 00100, Kenya
>> Tel: +254 20 7623436
>> Skype: mickwilson20
>> Fax: +254 20 7624315
>> Email: mick.wilson@anonymised.com
>> Lat: 1°14'3.72"S Lon: 36°49'5.93"E
>> Web www.unep.net, www.unep.org
>>
>>
>> ------------------------------------------------------------------------
>>
>> ------------------------------------------------------------------------------
>> OpenSolaris 2009.06 is a cutting edge operating system for enterprises
>> looking to deploy the next generation of Solaris that includes the latest
>> innovations from Sun and the OpenSource community. Download a copy and
>> enjoy capabilities such as Networking, Storage and Virtualization.
>> Go to: ``[http://p.sf.net/sfu/opensolaris-get](http://p.sf.net/sfu/opensolaris-get)
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> ``[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)
>
>
--
Justin Deoliveira
OpenGeo - ``[http://opengeo.org](http://opengeo.org)
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: ``[http://p.sf.net/sfu/opensolaris-get](http://p.sf.net/sfu/opensolaris-get)
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)
