[Featureserver] PostGIS insert statement question

[Jennifer Strahan]

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. 

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