I may be missing something here, but can't you just import the shapefile into postgres and do the JOIN as a view in the database and serve the WMS from the database store?
On 11/22/2010 4:39 PM, Andrea Aime wrote: > On Mon, Nov 22, 2010 at 9:19 PM, Flavio Carmo<[email protected]> > wrote: > >> Charles, >> i've downloaded and installed the beta1. I got the 1st part working now, a >> view from my nonspatial table, working in a Postgres Store. >> I just published my shapefile when the 1st problem showed: the shapefile >> layer and the view are in separated stores. The 2nd one come when i tried to >> make a query on a layer: i cant create a query on a layer, just in the >> database, so, back to square one. >> Anyone got some new ideas of how can i make this work? Or this is a feature >> not present in the current geoserver? >> > Definitely not present > Also definitely doable, but a non trivial amount of work, requires > some knowledge > of both Geotools and GeoServer. > > Cheers > Andrea > > > ----------------------------------------------------- > Ing. Andrea Aime > Senior Software Engineer > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584962313 > fax: +39 0584962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ----------------------------------------------------- > > ------------------------------------------------------------------------------ > Increase Visibility of Your 3D Game App& Earn a Chance To Win $500! > Tap into the largest installed PC base& get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Stephen Crawford Center for Environmental Informatics The Pennsylvania State University [email protected] ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
