The whole code would be a bit lengthy but this is the important part:

CREATE MATERIALIZED VIEW view_basicview_english AS SELECT
basicdata.the_geom::GEOMETRY(PointZ,4326) AS the_geom, ...

@julian:
psql shows a correct geometry column in that view: 
the_geom                            | geometry(PointZ,4326)       |          
| main        |
If I connect the DB through Qgis directly the column is recognized and I can
load and display the contents of the view correctly



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Problems-creating-a-Geoserver-Layer-on-a-PostGIS-View-tp5194895p5194936.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to