On 02/03/11 07:19, Robert Buckley wrote:
Hi,
Ubuntu 10.04
geoserver-2.0.2
postgresql 8.4
postgis
I am experiencing the following:
I can edit a postgis database geometry in Quantum GIS but I can´t
"insert" into a postgis table inserted with shp3pgsql. ( I used the
opengeo-suite windows version to upload the shp)
my error is here message is here ..
http://permalink.gmane.org/gmane.comp.gis.geoserver.user/26390
After days of scratching around the forums and reading this...
http://lists.osgeo.org/pipermail/openlayers-users/2010-March/016801.html
..I decided to do the same a make a simple table in postgis - 1 x "id"
column (type - integer, primary key, NotNull) and 1 x "the_geom" column
( type - geometry)
I loaded it into geoserver and was able to start editing immediately!!!!
Is it then something to do with the constraints inserted by
shp2pgsql?..( I removed all of them one by one and tested the insert,
but it still didn´t work)
Possibly do to with the GID column? I ccan´t remove this column without
breaking the geometry structure.
Idon´t understand what the problem is with the table imported from a
shapefile using shp2pgsql
Hi Robert,
The error message coming from Geoserver suggests that a prepared
statement is failing on the database. Can you try editing your
postgresql.conf to enable statement logging and restart PostgreSQL? Then
next time Geoserver throws an error, you can look in the log file to see
the exact SQL commands that were executed.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
