Iris,
One of the common problems mentioned at
http://docs.geoserver.org/latest/en/user/data/postgis.html is, "that the table
must have a primary key. A table without a primary key is considered read only
to GeoServer". This is one thing to check.
Kind regards,
Edward
Date: Fri, 4 May 2012 10:25:07 +0200
From: [email protected]
To: [email protected]
Subject: [Geoserver-users] WFS-T SQL-View read-only
Hallo,
I am trying to edit an WFS-T layer based on a view of a postgis
table with OpenLayers or MapInfo, but I get the error message, that
the table is read-only.
I use GeoServer 213 and create a sql View of a layer in Geoserver:
select flg_id, fl_id, geom_art_id, geom_poly from
gruen.flaeche_geom. I select the column flg_id as primary key and
set the srid and the geometry type of the geometry column. When I
asked geoserver to choose the geometry type and srid geoserver
suggests Polygon as geometry type and does not choose any srid, even
though I set the geometry type and srid in the geometry_columns
table in postgis as MULTIPOLYGON and 31466.
I can visualise the data, but when I try to save changes, I get the
error, that the table is read-only (flaeche_geom is read-only)
When I try editing tables without setting up a view in Geoserver, I
do not have a problem editing the tables.
Any ideas, why I cannot edit the view?
Thanks,
Iris
--
Iris Rittinger
Terraplan
Gewerbestr. 33
79229 Schallstadt
www.terraplan.com
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
