[QGIS-trac] Re: [Quantum GIS] #2819: Copied record field mismatch from shapefile to postgis

[Quantum GIS]

#2819: Copied record field mismatch from shapefile to postgis
------------------------------------------------+---------------------------
   Reporter:  bonzai                            |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.5.0
  Component:  Data Provider                     |            Version:  1.4.0        
   Keywords:                                    |   Platform_version:               
   Platform:  Gentoo                            |           Must_fix:  No           
Status_info:  1                                 |  
------------------------------------------------+---------------------------

Comment(by bonzai):

 Replying to [comment:1 jef]:
 > The field values are assigned in order not by name.   Does the attribute
 order in your postgis table match the order of fields in the shapefile's
 dbf?

 Looking in layers' properties attribute tab I've found this:

 SHAPEFILE[[BR]]
 -|id|name[[BR]]
 1|0 |app_id[[BR]]
 2|1 |su_id[[BR]]
 3|2 |su <-------[[BR]]
 4|3 |phase[[BR]]
 5|4 |date[[BR]]

 POSTGIS[[BR]]
 -|id|name[[BR]]
 1|0 |app_id[[BR]]
 2|2 |su_id[[BR]]
 3|3 |su <-------[[BR]]
 4|4 |phase[[BR]]
 5|5 |date[[BR]]

 So it seems thats records have the same order but different ids.
 A further information that could you help: the shapefile is the result of
 'Export as shapefile' QGIS command.

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