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
I am confused about your error message. Does your database have a geometry_columns table? If not, it has not been configured as a spatial database. One way to do this is: create language plpgsql; -- not required on some installations \i /some/path/postgis.sql \i /some/path/spatial_ref_sys.sql (There are other ways such as creating it with a spatially-enabled template. The above is just the old-fashioned way I do it.) And the usual advice such as checking to make sure you are connecting to the correct database in your cluster, not importing into one while publishing from another. Kind regards, Ben. On 27/03/12 21:44, vrbikdan wrote: > Ok, so if I understand well. If I use during transform shp to postgis "load > into geography column" it will generate this problem? But problem is, that > without this I can't create database, it writes that "Failed in pgui_exec(): > ERROR: relation "geometry_columns" does not exist". But I suppose, that > this isn't question in geoserver forum, but postgis isn't it? :) > > Thanks > Dan > > -- > View this message in context: > http://osgeo-org.1560.n6.nabble.com/missing-geometry-after-create-sql-view-tp4660559p4660903.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > 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 > -- Ben Caradoc-Davies <[email protected]> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ 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
