Hi List, I've this big set of shp-files per country. I've imported every shp-file per country in a table (so for every country I've a table 'roads' etc etc).
Then I tried to make a view over all countries with something like: create or replace view all_roads as select * from nld_roads union all select * from lux_roads union all select * from bel_roads Not sure if this is efficient, but anyway... If I try to render nld_roads with a given mapnik-config all is fine. But when I try to render all_roads (that is using the VIEW as datasource) I see error messages in my postgis-log: 2008-08-18 18:19:50 CEST ERROR: function extent() does not exist at character 61 2008-08-18 18:19:50 CEST HINT: No function matches the given name and argument types. You may need to add explicit type casts. 2008-08-18 18:19:50 CEST STATEMENT: select xmin(ext),ymin(ext),xmax(ext),ymax(ext) from (select extent() as ext from all_roads) as tmp And looking in the postgis-plugin src I see: std::string table_name=table_from_sql(table_); std::ostringstream s; s << "select f_geometry_column,srid,type from "; s << GEOMETRY_COLUMNS <<" where f_table_name='" << table_name<<"'"; so apparently stuff went wrong because the geometry-column in the VIEW is not registred as a geometry-column in the table 'geometry_columns'. Now, normally you don't register a geometry column in a view again for a view. So my question: should/can I (re)register the geometry-column (again) for the view (over my tables)? Or is there another way to be able to aggragate stuff over several tables instead of using a view? Or am I on the wrong track anyway ... Thanks in advance & regards, Richard Duivenvoorde _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
