On Wed, Mar 28, 2012 at 3:31 AM, Ben Caradoc-Davies
<[email protected]> wrote:

> Whenever you create a view, you must also create an entry in
> geometry_columns for it.
>
> http://docs.geoserver.org/latest/en/user/data/postgis.html#publishing-a-postgis-view



Ben, this is not required when doing a "sql view", that is, configuring the
sql
from the GUI. Unfortunately sql views containing geography columns in
postgis do not work due to a problem in the sql dialect type mapping (and
lack
of tests).

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 339 8844549

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

-------------------------------------------------------
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to