[postgis-users] How to set up a db for editing in postgis?

[Robert Buckley]

Hi,

I have been trying to edit with a postgis databank for ages now and can´t seem 
to get it working.

I have geoserver setup in tomcat6 on ubuntu 10.04.
I have postgres8.4 running with postgis.
I can connect to postgis through pgadmin
I have set up an editing web interface with geoext/openlayers

I have tried editing a geoserver layer from a shapefile and it works ok!!!  I 
had to play with the permissions and found that I could only edit when the file 
permissions were 0777

To edit in postgis I first created a db in postgis called "zgb"  the owner is my 
postgresql user"geoadmin1"

The tables in postgis give all privilages to public
In geoserver the files are owned by "tomcat6" except "www" which is owned by 
"geoadmin1" - this is so that I can´t edit the .js and.html in winscp

I am really confused as to how to set permissions to be able to edit a 
postgisdb. How should the privalages be set to be able to edit geometries?

If it turns ot that this is not really an issue, what else could be restricting 
the editing ability of my app?

What should I generally watch out for to be able to edit postgis?

thanks for any help,

Robert


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110228/554cdebe/attachment.html>