[Featureserver] Delete From PostGIS Problems

[Aaron Sutula]

Hi John,
I am using psycopg2 (python-psycopg2-2.0.6-2). I did not make any 
changes to FeatureServer to get it working (except for delete, of 
course). Could psycopg2 have something to do with why I am getting an 
error when trying to delete a feature?
- Aaron

John Cartwright wrote:
> 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
>>     
>
> _______________________________________________
> Featureserver mailing list
> Featureserver at openlayers.org
> http://featureserver.org/mailman/listinfo/featureserver
>