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