[QGIS-trac] [Quantum GIS] #1328: PostGIS layer editing - prepared statement "addfeatures" is not removed on failed saving added features

[Quantum GIS]

#1328: PostGIS layer editing - prepared statement "addfeatures" is not removed on
failed saving added features
---------------------------------------------------------+------------------
   Reporter:  smizuno                                    |              Owner:  nobody       
       Type:  bug                                        |             Status:  new          
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.0.0
  Component:  Data Provider                              |            Version:  HEAD         
   Keywords:                                             |   Platform_version:               
   Platform:  All                                        |           Must_fix:  No           
Status_info:  0                                          |  
---------------------------------------------------------+------------------
 The situation: a table having a column contraint, such as NOT NULL, on a
 column other than the object id; used integer type in this case.

 1. start Editing[[BR]]
 2. add a feature[[BR]]
 3. in the Enter Attribute Values dialog make the field that has the
 constraint have a value that violates the constraint, like a blank
 field[[BR]]
 4. stop Editing, save the changes. Gets error message: {{{...NULL value in
 column...}}}[[BR]]
 5. in Attribute Table, fix the value to a valid one.[[BR]]
 6. now stop Editing, save changes. Gets error message: {{{...prepared
 statement "addfeatures" already exists... }}}

 Can't get rid of the error until the layer is loaded again.

 I was using a multipoint layer, but believe this affects all types.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1328>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats