On Wed, Apr 23, 2014 at 3:23 AM, Mark Grantham <[email protected]>wrote:
> 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?
>
We also need to upgrade the jdbc driver, but trying to do so breaks other
things,
see linked issue in there
Cheers
Andrea
--
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
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
