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