[Featureserver] PostGIS insert statement question

[Christopher Schmidt]

On Fri, May 15, 2009 at 04:47:34PM -0500, Jennifer Strahan wrote:
> Hi Josh,
> 
> I'm using a version from svn trunk that I checked out on May 8, 2009
> 
> I removed the geometry= line from my layer config and am still getting 
> the same error. 

The only thing I can think of is that you have another
featureserver.config somewhere that is causing problems. Try changing
your layer name? Looking at the code, the *default* should be the_geom;
there is no code anywhere that I can see which uses 'geoemetry' without
you explicitly specifying it as such...

-- Chris

> Thanks,
> Jennifer
> 
> Josh Livni wrote:
> > Odd, it looks like the current svn update method should work with any 
> > geometry column name you specify..
> >
> >  - What version are you using (svn trunk?) 
> >  - What happens if you remove the geometry= line from your layer config?
> >
> >  -Josh
> >
> >
> > On Fri, May 15, 2009 at 1:33 PM, Jennifer Strahan 
> > <jennifer at greeninfo.org <mailto:jennifer at greeninfo.org>> wrote:
> >
> >     Hello Everyone,
> >
> >     I'm hoping someone can suggest how to solve an error I'm getting when
> >     trying to insert a record into a PostGIS datasource:
> >
> >     An error occurred: column "geometry" of relation
> >     "padus_v1_mn_edits" does not exist
> >     LINE 1: ...T INTO "padus_v1_mn_edits" (comm_date, wdpa_name,
> >     geometry, ...
> >                                                                 ^
> >
> >      File "/var/www/featureserver-pine/web_request/handlers.py", line
> >     219, in cgi
> >        accepts = accepts )
> >      File "/var/www/featureserver-pine/FeatureServer/Server.py", line
> >     167, in dispatchRequest
> >        result = method(action)
> >      File
> >     "/var/www/featureserver-pine/FeatureServer/DataSource/PostGIS.py",
> >     line 116, in create
> >        cursor.execute(str(sql), self.feature_values(feature))
> >
> >
> >
> >     Looks like the insert statement uses the column name "geometry"
> >     when it
> >     should be "the_geom"
> >
> >     Below is my config for the layer.  Any help would be much appreciated.
> >     I guess I can just rename my geometry column.  But I was hoping to get
> >     it working with the current name.
> >
> >     Thanks,
> >     Jennifer
> >
> >     #Use this layer to submit and display user edits
> >     [padus_v1_mn_edits]
> >     type=PostGIS
> >     dsn=dbname=db_pine password=xxxxxx user=pine
> >     layer=padus_v1_mn_edits
> >     geometry=the_geom
> >     fid=gid
> >     srid=900913
> >     attribute_cols=us_id, manag_desc, wdpa_name, gis_acres, gap_status,
> >     gis_source, sourcedate, class_desc, owner_desc, comments, comm_name,
> >     comm_org, comm_email, comm_date
> >     gaping_security_hole=yes
> >
> >     --
> >     Jennifer Strahan, GIS Specialist
> >     GreenInfo Network - www.greeninfo.org <http://www.greeninfo.org> -
> >     Information and Mapping in the Public Interest
> >
> >     **As of Oct. 13, 2008 we have a new address**
> >     564 Market Street, Suite 510
> >     San Francisco CA 94104
> >
> >     Phone: 651-917-0191
> >     Fax: 415-979-0371
> >     Email: jennifer at greeninfo.org <mailto:jennifer at greeninfo.org>
> >
> >     _______________________________________________
> >     Featureserver mailing list
> >     Featureserver at openlayers.org <mailto:Featureserver at openlayers.org>
> >     http://featureserver.org/mailman/listinfo/featureserver
> >
> >
> 
> 
> -- 
> Jennifer Strahan, GIS Specialist
> GreenInfo Network - www.greeninfo.org -
> Information and Mapping in the Public Interest
> 
> **As of Oct. 13, 2008 we have a new address**
> 564 Market Street, Suite 510
> San Francisco CA 94104
> 
> Phone: 651-917-0191
> Fax: 415-979-0371
> Email: jennifer at greeninfo.org 
> 
> _______________________________________________
> Featureserver mailing list
> Featureserver at openlayers.org
> http://featureserver.org/mailman/listinfo/featureserver

-- 
Christopher Schmidt
MetaCarta