Hi, Thanks for the reply.
I am aware that I need to set up the spatial_re and geometry columns in order to store spatial information. My question was set in the context of specifically trying to edit the geometry. I have set up a postgresql database with postgis and I can import a shapefile into it. 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. which permissions and rights should be adjusted to enable editing in the database? yours, Robert ________________________________ Von: Jean-François Gigand <jean-franc...@gigand.fr> An: PostGIS Users Discussion <postgis-users@postgis.refractions.net> Gesendet: Montag, den 28. Februar 2011, 19:24:30 Uhr Betreff: Re: [postgis-users] How to set up a db for editing in postgis? Hi, To use a PG database with PostGIS, it needs the "geometry_columns" and "spatial_ref_sys" tables, and a set of PostGIS functions. To set these up, you need to run the SQL files : /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql (the path may vary, if your PG version is different - these are those of my Debian install). You need to run these SQL files on your database, as an administrator user. JF 2011/2/28 Robert Buckley <robertdbuck...@yahoo.com>: > 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 > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users