[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:3 jef]:
 > Might the geometry column in postgis not be the last column?
 Actually it's not a table but a view with insert,update,delete rules:

 CREATE OR REPLACE VIEW dataschemaname.w_core_geom_sus AS
  SELECT g.app_id, g.geom, s.app_id AS su_id, s.short_def AS su,
 ph.short_def AS phase, s.date
    FROM dataschemaname.core_geom_sus g
    LEFT JOIN dataschemaname.core_std_sus s ON g.su_id = s.app_id
    LEFT JOIN dataschemaname.core_voc_phases ph ON s.phase_id = ph.app_id;

 As you can see the geometry column is the second one. Should it be the
 last one?
 It's not a big issue but I've never heard about this...

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