On Wed, May 2, 2012 at 4:26 PM, atu <[email protected]> wrote:
> I have a postgis database with more schemas.
> By defining a geoserver datastore postgis layer, if the schema field is
> empty, geoserver takes "public" as default schema. It is impossible to use
> more postgres schemas which are defined in the postgres search_path. Is
> there any way to configure geoserver that it dosent add schema reference in
> sql queries ?
>
> geoserver 1.7
>
This GeoServer version is too old and not supported anymore.
As far as I know you can have GeoServer 2.x access tables from multiple
schemas
if you don't specify one, althought trouble might arise if you have the
same table
name in two different schemas (the code internally does not keep track of
what schema each table is coming from).
Normally I just create multiple stores, one per schema, to avoid too many
connections the connection pool can be configured at the web container
level and referred to using JNDI.
Or, someone can provide patches to track the schema each table is coming
from, and then we can have a single store working fine against multiple
schemas.
Cheers
Andrea
--
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
