Bug report #5938

primary key/autoincrement not imported in sqlite

Added by Yves Jacolin over 9 years ago. Updated almost 3 years ago.

Category:C++ plugins/Offline editing
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:15372


When a postgis table with a primary key + autoincrement field is imported in sqlite with the offline plugin, the schema is a little bit different:

                                         Table « public.XXXX

    Column     |       Type       |                                    Modificateurs
 ogc_fid        | integer          | not NULL by default, nextval('public.XXXX_ogc_fid_seq'::regclass)
 geom           | geometry         |                                                                                                               
 identifiant    | character(16)    |   
 numero         | character(10)    |                                      
 type           | character(50)    |                                                                      
 name | character(50)    |                                     
 longueur       | double precision |                                                                     
Index :
    "XXXX_pk" PRIMARY KEY, btree (ogc_fid)
    "XXXX_geom_idx" gist (geom)
Contraintes de vérification :
    "enforce_dims_geom" CHECK (st_ndims(geom) = 2)
    "enforce_geotype_geom" CHECK (geometrytype(geom) = 'LINESTRING'::text OR geom IS NULL)
    "enforce_srid_geom" CHECK (srid(geom) = 21781)
  'ogc_fid' INTEGER,
  'identifiant' TEXT,
  'numero' TEXT,
  'type' TEXT,
  'name' TEXT,
  'longueur' REAL,
  "Geometry" LINESTRING

"PRIMARY KEY" and "AUTOINCREMENT" is missing. In that case it should be better to not import back this field in the postgis table, but if it is not possible the sqlite scheme is not correct and the user need to define ogc_fid field value when editing offline.


#1 Updated by Alexander Bruy over 9 years ago

  • Category changed from Python plugins to C++ Plugins

#2 Updated by Paolo Cavallini over 9 years ago

  • Target version set to Version 2.0.0

#3 Updated by Jürgen Fischer over 7 years ago

  • Target version changed from Version 2.0.0 to Future Release - Lower Priority

#4 Updated by Jürgen Fischer over 7 years ago

  • Category changed from C++ Plugins to C++ plugins/Offline editing

#5 Updated by Jürgen Fischer over 7 years ago

  • Subject changed from [offlline] primarykey/autoincrement not import in sqlite to primary key/autoincrement not imported in sqlite

#6 Updated by Giovanni Manghi over 4 years ago

  • Regression? set to No
  • Easy fix? set to No

#7 Updated by Luigi Pirelli about 3 years ago

  • Description updated (diff)

FYI related PR-Fix has been closed due to lack of comments: https://github.com/qgis/QGIS/pull/8023

#8 Updated by Giovanni Manghi almost 3 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF