<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt"><span class="cgSelectable" style="cursor: pointer;" title="Alle Mails mit diesem Betreff anzeigen">Hi,<br><br>Thanks for the reply.<br><br>I am aware that I need to set up the spatial_re and geometry columns in order to store spatial information.<br>My question was set in the context of specifically trying to edit the geometry.<br><br>I have set up a postgresql database with postgis and I can import a shapefile into it.<br>For some reason though I cannot edit the data through wfs-t and I am wondering if it to do with permissions/restrictions etc. If I try to edit the shapefile directly through geoserver it works ok.<br><br>which permissions and rights should be adjusted to enable editing in the database?<br><br>yours,<br><br>Robert<br></span><div><br></div><div style="font-family: arial,helvetica,sans-serif;
font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">Von:</span></b> Jean-François Gigand <jean-francois@gigand.fr><br><b><span style="font-weight: bold;">An:</span></b> PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Gesendet:</span></b> Montag, den 28. Februar 2011, 19:24:30 Uhr<br><b><span style="font-weight: bold;">Betreff:</span></b> Re: [postgis-users] How to set up a db for editing in postgis?<br></font><br>Hi,<br><br>To use a PG database with PostGIS, it needs the "geometry_columns" and<br>"spatial_ref_sys" tables, and a set of PostGIS functions.<br>To set these up, you need to run the SQL files :<br>/usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql<br>/usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql<br><br>(the path may vary, if your PG
version is different - these are those<br>of my Debian install).<br>You need to run these SQL files on your database, as an administrator user.<br><br>JF<br><br><br>2011/2/28 Robert Buckley <<a ymailto="mailto:robertdbuckley@yahoo.com" href="mailto:robertdbuckley@yahoo.com">robertdbuckley@yahoo.com</a>>:<br>> Hi,<br>><br>> I have been trying to edit with a postgis databank for ages now and can´t<br>> seem to get it working.<br>><br>> I have geoserver setup in tomcat6 on ubuntu 10.04.<br>> I have postgres8.4 running with postgis.<br>> I can connect to postgis through pgadmin<br>> I have set up an editing web interface with geoext/openlayers<br>><br>> I have tried editing a geoserver layer from a shapefile and it works ok!!!<br>> I had to play with the permissions and found that I could only edit when the<br>> file permissions were 0777<br>><br>> To edit in postgis I first created a db in postgis called
"zgb" the owner<br>> is my postgresql user"geoadmin1"<br>> The tables in postgis give all privilages to public<br>> In geoserver the files are owned by "tomcat6" except "www" which is owned by<br>> "geoadmin1" - this is so that I can´t edit the .js and.html in winscp<br>><br>> I am really confused as to how to set permissions to be able to edit a<br>> postgisdb. How should the privalages be set to be able to edit geometries?<br>><br>> If it turns ot that this is not really an issue, what else could be<br>> restricting the editing ability of my app?<br>><br>> What should I generally watch out for to be able to edit postgis?<br>><br>> thanks for any help,<br>><br>> Robert<br>><br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@postgis.refractions.net"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></div>
</div><br></body></html>