Hi, I am currently testing reading vector data from a PostGIS DB (version 9.3) using GeoServer 2.5. I wanted to try using a materialized view for performance (as suggested in http://www.slideshare.net/geosolutions/geoserver-on-steroids).
I created a "normal" view, added it to geometry_columns and was able to add it as a layer in GeoServer. I then created a Materialized View using the same method, and added it to geometry_columns. When I went to add the new layer in GeoServer, the materialized view did not display. I then created a view which did a SELECT * on the materialized view, added it to geometry_columns and was able to add it to GeoServer. I thought that this should work in 2.5 after https://jira.codehaus.org/browse/GEOT-4635 was fixed - has anyone else tried this? Thanks Mark ------------------------------------------------------------------------------ Start Your Social Network Today - Download eXo Platform Build your Enterprise Intranet with eXo Platform Software Java Based Open Source Intranet - Social, Extensible, Cloud Ready Get Started Now And Turn Your Intranet Into A Collaboration Platform http://p.sf.net/sfu/ExoPlatform _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
