[QGIS-trac] [Quantum GIS] #2137: Wrong ID provided to the PostGIS on save

Quantum GIS qgis at qgis.org
Sun Nov 22 10:53:41 EST 2009


#2137: Wrong ID provided to the PostGIS on save
------------------------------------------------+---------------------------
   Reporter:  fsat                              |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.4.0
  Component:  Data Provider                     |            Version:  HEAD         
   Keywords:                                    |   Platform_version:               
   Platform:  Gentoo                            |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 I'm trying to use qgis with my PostGIS database. I have only 3 tables for
 different kinds of components. So I've created a couple of updatable views
 to make a work with QGIS more comfortable and to keep my internal
 structure. But when I'm setting a unique ID to the element (in QGIS) I
 receive a complaints about duplicate ID.
 For example: I have an empty view (but not empty table with elements), but
 I know - the ID=15 is unique, I create a new element in the layer
 associated with this view and set the ID to 15, but on save I receive
 error. After the empty record created manualy with ID=15 and I'm saving to
 this view - I see ID's started from 16. Inspite of provided data to ID
 field it is counted automaticaly.

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


More information about the QGIS-trac mailing list