[Featureserver] Delete From PostGIS Problems

John Cartwright john.c.cartwright at comcast.net
Wed Jan 30 16:54:17 EST 2008


Hi Aaron,

as an aside, are you using psycopg1 or psycopg2 to connect  
FeatureServer w/ your PostGIS database?  If you're using psycopg2,  
could you share whatever changes you had to make to FeatureServer to  
get it to work?

Thanks!

--john

On Jan 30, 2008, at 2:33 PM, Aaron Sutula wrote:

> Hi Everyone,
>
> I have configured FeatureServer 1.11 to read data from a PostGIS
> database and serve that data to an OpenLayers web client. I have been
> very satisfied with how straight forward it was to get my web client
> creating and modifying features in my database via FeatureServer. The
> next step is deleting features... I am getting a Python error when
> attempting to delete a feature. The command
>
>    curl -X DELETE
> http://localhost/featureserver-1.11/featureserver.cgi/postgis/29
>
> results in the following traceback:
>
>    An error occurred: int argument required
>      File "/var/www/html/featureserver-1.11/FeatureServer/Server.py",
> line 281, in cgiHandler
>        format, content = service.dispatchRequest( params, path_info,
> host, post_data, request_method, accepts )
>      File "/var/www/html/featureserver-1.11/FeatureServer/Server.py",
> line 145, in dispatchRequest
>        result = method(action)
>      File
> "/var/www/html/featureserver-1.11/FeatureServer/DataSource/ 
> PostGIS.py",
> line 160, in delete
>        cursor.execute(str(sql), {self.fid_col: action.id})
>
> I can access that same feature with other http methods with no  
> problems.
>
> I am running FeatureServer 1.11 under httpd-2.2.6-3 with mod_cgi and I
> have python-2.5.1-15.
>
> Has anyone seen this problem before? Thank you for any help you can  
> provide.
>
> - Aaron
> _______________________________________________
> Featureserver mailing list
> Featureserver at openlayers.org
> http://featureserver.org/mailman/listinfo/featureserver




More information about the Featureserver mailing list