[postgis-users] insert to database - error

[Robert Buckley]

________________________________

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

yours,

Robert


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110302/6c4903de/attachment.html>