Ouch, this is a bit of a showstopper. So aside from creating a view and registering it one by one, I suppose there is no other way of adding dynamic tables. Really curious now how people are able to link BI reports with Geoserver.
Anyway Thanks again, Andrea. Mario. On Mon, Feb 14, 2011 at 7:35 PM, Andrea Aime <andrea.a...@geo-solutions.it> wrote: > On Mon, Feb 14, 2011 at 10:57 AM, Mario Basa <mario.b...@gmail.com> wrote: >> Hello, >> >> I have a lot of PostgreSQL attribute tables which I would like to link >> to a single geographic table on demand to create thematic maps. >> >> My parametric sql statement is: >> >> select a.*,the_geom from %link_table% a, maptable b where a.code = b.code >> >> I then created a "dummy" table that contains just a "code" field and >> used the "dummy" as the default value of the %link_table% so that I >> can register the layer. >> >> My problem is when I make a wms/wfs request with a >> "viewparams=link_table:attribtab1", I can only get the "code" field >> and none of the other attribute fields of the table. >> >> Since all of my attribute tables have different schemas, is there any >> of forcing geoserver to read the returned schema from the sql request, >> and not just the registered field name. > > Can't do this, the feature type has to be stable. > With sql views you can do whatever you want, but the set of returned > attributes > must be fixed. > > In GeoServer there is no concept of layer whose attribute change over time, > it would also break badly most WFS clients > > 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 333 8128928 > > 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 > > ------------------------------------------------------- > ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
